jwcolby
jwcolby at colbyconsulting.com
Sun Jun 13 08:47:39 CDT 2004
OK, I got it. Thanks, 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:37 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Date syntax in SQL Server The CONVERT function is provided to help with converting a DATETIME or SMALLDATETIME variables, or any other string that holds a valid date, into different date/time display formats. The CONVERT function is called using the following syntax: CONVERT ( data_type [ ( length) ] , expression [ , style ] ) Where data_type [(length)] is the target data type format and length, expression is any valid Microsoft expression that represents the date/time you want to display, and style specifies the output format for the data/time. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Saturday, June 12, 2004 9:12 PM 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