Literal Date Expressions

Note: Extended stored procedures are no longer supported.

Date expressions can be any valid SQL Server date expression. Here are some examples

"4/2/2001 13:00:00:00"

"4/2/2001 12:00 PM"

"2001-4-2 1:00 AM"

Years expressed as two digits are interpreted as years in the 1900s. The SQL Server configuration option that supports a two-digit year cutoff is not used.