Perhaps CreateOdbcDate() is what you are after. -Mike Chabot
On 5/21/07, Rebecca Wells <[EMAIL PROTECTED]> wrote: > 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!!! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
