TurboDB Engine Documentation
DateTime Formats
Previous  Top  Next


Datetime literals are composed of a date literal and a time literal separated by an underscore, '_'. Do not use quotes with datetime literals.
SELECT *
FROM WorkOrder
WHERE StartTime >= 31.1.2001_14:10:00

The other way to specify a datetime is to enclose it in double quotes:
SELECT *
FROM WorkOrder
WHERE StartTime >= "1/31/2001 2.10 pm"
or
SELECT *
FROM WorkOrder
WHERE StartTime >= "2001-1-31 14:10"