I have a table consisting of several thousand entries, with each entry
distinguished by it's item number and timestamp (given in unix time).
Currently I am using "SELECT * FROM TABLE WHERE BEGIN >= convertedDateBegin
AND END <= convertedDateEnd "
I need to select all items entered between 2 specified datetimes, but my
conversion doesn't seem to be working. Does SQL have a function for
converting dates in the form of mm/dd/yyyy hh:mm:ss into unix time?
Lead Software Engineer
Razorvision Technology, Inc.