>I've got a strange one, its pretty strange to me, maybe not to one of you...
>
>I insert a date for a record using this set statement....
><cfset form.record_modifieddate=createodbcdate(now())>
>
>and inside the database the record looks like this
>
>8/1/2003 2:47:29 AM
CreateODBCDate(now()) would not put that time in the database.
CreateODBCDate(now()) assumes midnight and will always put:
{d '2003-08-01'}
Which will show as 8/1/2003 00:00:00
CreateODBCDateTime(now()) would put the time. So double check that
you're using CreateODBCDate.
If you need the time in there and you need to query for any times
within a date, you'll need to do a range query:
record_modifieddate >=
#CreateODBCDateTime(CreateDateTime(year(now()), month(now()),
day(now()), 00, 00, 00))# and
record_modifieddate <=
#CreateODBCDateTime(CreateDateTime(year(now()), month(now()),
day(now()), 23, 59, 59))#
--
Bud Schneehagen - Tropical Web Creations, Inc.
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
Web Based Solutions / eCommerce Development & Hosting
http://www.twcreations.com/ - http://www.cf-ezcart.com/
954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at
http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
