Hi
I have a date field in my sql 2000 DB called "dttripstart" It the following value:"2000-11-22 06:39:49.000" I am trying to do a select statement where dttripstart = '2000-11-22 ' How do I specify this?
Thanking you in advance
PORRASTAR
Printable View
Hi
I have a date field in my sql 2000 DB called "dttripstart" It the following value:"2000-11-22 06:39:49.000" I am trying to do a select statement where dttripstart = '2000-11-22 ' How do I specify this?
Thanking you in advance
PORRASTAR
you can use this in ado:
strSQL="SELECT * FROM TableName WHERE dttripstart=#'2000-11-22#
rs.open strSQL,connection,---,---,----
Maybe you can also place the LIKE operator in the SQL string...
In SQL Server 2000, use the CONVERT function to chop off the time:
SELECT * FROM TableName WHERE dttripstart = CONVERT(CHAR(10), DateCreated, 102) = '11/22/2000'