On 5/12/2010 9:48 PM, Richard Meredith-Hardy wrote: > You can sometimes give a date in 'native' format to a db and it will accept > it, but it is essentially ambiguous ie 1/5/2010 - is this 1 may or 5th Jan? > The createodbcDate() or createodbcdatetime() functions are your friend.
in that case, your friend for sql server is SET DATEFORMAT, ie SET DATEFORMAT mdy tells the server that following that statement, date data will be in the month-day-year format. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333607 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
