Oops. My dates are always inserted without a specific time. When I edited
the date field of a record to add a time, SELECT * FROM table WHERE myDate =
Cast('5/7/2003' as datetime) didn't return the record with the newly
inserted time! So I guess that's "why not?" :)
----- Original Message -----
From: "Dina Hess" <[EMAIL PROTECTED]>
To: "SQL" <[EMAIL PROTECTED]>
Sent: Thursday, June 19, 2003 2:55 PM
Subject: Re: Get records that match a single date.
> > Do it where you search between your date at 00:00:01 and your date at
> 23:59:59.
>
> Why not just...
>
> WHERE myDate = Cast('5/7/2003' as datetime)
>
> ?
>
> ~Dina
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=6
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
