Option 1. Use the CONVERT() function to get strip the time from the
date. Then, you have a date string to which you can compare.
Option 2. Use a combination of DAY() MONTH() YEAR() SQL functions.
(This isn't the best solution, but it would work.)
Ex:
WHERE
DAY(dateCol)=#dayVar#
AND
MONTH(dateCol)=#monthVar#
AND
YEAR(dateCol)=#yearVal#
-----Original Message-----
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 9:12 AM
To: CF-Talk
Subject: RE: SQL question
I tried that too and no records are returned.
-----Original Message-----
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 10:09 AM
To: CF-Talk
Subject: RE: SQL question
How about using...
WHERE dateCreated LIKE '%4/2/2007%'
-----Original Message-----
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 10:05 AM
To: CF-Talk
Subject: RE: SQL question
I tried that also and no records are returned.
-----Original Message-----
From: Che Vilnonis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 10:01 AM
To: CF-Talk
Subject: RE: SQL question
How about you simply use WHERE dateCreated = '4/2/2007' Basically, lose
the
padding zeros.
~Che
-----Original Message-----
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 03, 2007 9:59 AM
To: CF-Talk
Subject: SQL question
I am using MS SQL and have a field with data type DateTime.
I want to find all records with the day 4/2/2007?
If I do
WHERE dateCreated = '04/02/2007'
I get no records and I have lots of records like this in the database:
4/2/2007 9:57:57 AM
4/2/2007 10:57:57 AM
4/2/2007 5:57:57 AM
4/2/2007 2:57:57 AM
I want to keep the time in my data so I don't want to modify the data
type.
How do I write my query to find all records on the day 4/2/2007?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274423
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
