What you show the user is a formated date. What you store in the database should be native to the database. A good suggestion would be to store the date/time into an ODBC Date/Time format, so you can convert it easily into any format you like. For user input, you just need to roll your own process to validate the string.
Teddy On 10/31/06, Richard White <[EMAIL PROTECTED]> wrote: > > thanks for the replies i will look into your suggesstions. > > Thanks david my database is mysql and it stores and outputs in the format > of yyyy/mm/dd but my app will be basedo n the UK so i need it in the format > of dd/mm/yyyy. > > I have been getting it out of the database and storing it in a sessiopn > variable for whenever i need it, i only format it using the dateformat > function in order to display it on screen. And am also having to formatr it > when i run a new query on the database with the date as it comes out of the > database as a timestamp so i have to convert it to back to the yyyy/mm/dd > format > > thanks > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258580 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
