Dates are not stored in a database as one format or another. A date in a database is simply a real number. The format comes into play in the presentation - in other words, the real number is formatted and displayed and the formatting is what controls the date that you see.
How are you displaying the date? Regards, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server >>> Find out how iMS Stacks up to the competition: >http://www.coolfusion.com/imssecomparison.cfm ----- Original Message ----- From: "James Matthews" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, February 05, 2002 9:36 PM Subject: ODBC Formatting? > Hi gang, > > I am inserting an ODBC date into an access database. It is being stored as > an American formatted date, I need it to be stored in Australian format. > > American format: 2/6/2002 1:17:26 PM > Australian Format: 6/2/2002 1:17:26 PM > > 6th Feb 2002 > > > I know there is a way to do this, i did it ages ago but i have forgotten how I > figured that one out...hehe. I believe I stored it in the format yyyy/mm/dd. > > Any ideas would be appreciated on how to do this. > > James. > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
