[dba-SQLServer] Date syntax in SQL Server

jwcolby jwcolby at colbyconsulting.com
Sat Jun 12 22:46:24 CDT 2004


What is the syntax for dates in SQL Server?

WHERE     (DateOfBirth >= CONVERT(DATETIME, '1970-01-01', 102))

I need to get rid of the convert.  Bracketing in ## doesn't work.

John W. Colby 
www.ColbyConsulting.com





More information about the dba-SQLServer mailing list