- see footer for list info -<
hi,
in my opinion the best way to store a date in a db is to create a date
object, by createdate(), create ODBCdate() and related functions, then you
can use lsdateformat(mask) and lstimeformat(mask) to format and display
retrivied dates..
salvatore
----- Original Message -----
From: "Stephen Adams" <[EMAIL PROTECTED]>
To: "Coldfusion Development" <[email protected]>
Sent: Tuesday, January 24, 2006 5:46 PM
Subject: [CF-Dev] Best way to format dates into an Access DB for UK
formatdates
- see footer for list info -<
HI,
I'm trying to get dates into an access db so that they are stored as
"dd/mm/yy" format and are displayed on my pages as "dd/mm/yy". I'm setting
the locale as UK, using setLocale("UK") in my application.cfm page. Then I'm
setting the format of dates using the LSDateFormat() function when I'm
saving the date. What's the best way to display to store and retrieve dates
into access.
Stephen
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
__________ Informazione NOD32 1.1376 (20060123) __________
Questo messaggio รจ stato controllato dal Sistema Antivirus NOD32
http://www.nod32.it
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<