Mike & Doris Manning
mikedorism at adelphia.net
Wed Jun 23 09:01:35 CDT 2004
Also be forwarned that SQL Server is just as picky as Access... "01-01-2004" is really "01-01-2004 00:00:00" If you store Null to a SQL Server date field, it saves as "12/31/1899 00:00:00" so you need to use Empty instead. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Wednesday, June 23, 2004 9:38 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Date syntax in SQL Server You don't need the convert. You can just go SELECT * FROM someWhere WHERE ADateColumn >= "01-01-2004" -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Sunday, June 13, 2004 12:12 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Date syntax in SQL Server But why does it need the convert? Just part of SQL Server? John W. Colby www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of vchas Sent: Sunday, June 13, 2004 12:00 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Date syntax in SQL Server 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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com