I'm converting a CF application from Oracle to MS SQL 2005 and found out that when you insert a date in to a datetime field in SQL, it creates a time (00:00:00) that includes either AM or PM according to when the record was inserted. What would be the best way to create a "safe" date to insert that will insure that the time is always the same, i.e. always "00:00:00:0 AM"?
PLEASE REPLY TO ME OFF LIST AT [EMAIL PROTECTED] AS I AM ON DIGEST AND DON'T HAVE TIME TO WADE THROUGH ALL THE MESSAGES. THANKS!!! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278829 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
