Howie, I need it stored as an australian format, if i try and compare an aus date to an american date won't it give me an incorrect result? I might just change it and store it in the db as 6-Feb-02 to save hassles. That would make life easier.
thanks anyway guys James. At 10:15 PM 2/5/2002 -0500, you wrote: >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. > > > ______________________________________________________________________ Get Your Own 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=coldfusionb 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
