Using CitectSCADA > Exchanging Data with Other Applications > Using Structured Query Language > Database independent date-time syntax
Database independent date-time syntax

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



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.