Database independent date-time syntax

For database independence, you can use the following syntax for dates and times:

[<format>'YYYY-MM-DD HH:MM:SS.FFFFFF']

where:

• <format> (the first character after the opening square bracket) needs to be one of the following:
• d - date
• t - time
• dt - date and time.

Whether you are specifying a date, time, or date and time, you need to provide the full 26 character string, for example:

[d'1995-02-18 00::00.000000']

Refer to the documentation that accompanied your SQL server for further information about SQL commands.