vchas
vchas at artronix-solutions.com
Sat Jun 12 22:59:36 CDT 2004
In sql dates are treated like strings, use single quotes not # Good Luck V www.vinniechas.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Saturday, June 12, 2004 8:46 PM To: 'Access Developers discussion and problem solving'; SQLServer Subject: [AccessD] Date syntax in SQL Server 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com