DateTime literals

[happyabc]

What is form prescribed by ANSI for DateTime literals.

 

[swampBoogie]

In ISO SQL datetime is a collective name for values of type date, time or timestamp.

date literals:

date '2004-04-23'

time literals:

time '03:56:28'

timestamp literals:

timestamp '2004-04-23 03:56:28'

Time and timestamp literals may have an optional fraction of seconds, e.g

timestamp '2004-04-23 03:56:28.234505678'

For time and timestamp values a time zone displacement may be included

time '03:56:28-01:30'

In addition to datetime values there is intervals which denotes periods of time. I don't if you are interested in that.

 

[happyabc]

Right, not interested in intravels; but what is the difference between ISO and ANSI SQL.

BTW, I wonder if you happen to know the rules for date/time literals in VB?

 

[swampBoogie]

There is no difference between ANSI and ISO SQL (in content). It is ISO that defines the standard and afterwards it is acknowlegded by national standard bodies.

Dates and times in VB are specified as

#2004-04-23# and #12:13:14#

There are some other date formats (depending on LCID settings) that are recognized.

 

[happyabc]

Thanks, swampBoogie.