[AccessD] Date syntax in SQL Server

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






More information about the AccessD mailing list