>- see footer for list info -< I used the following code to ensure UK date formatting works.
// set the locale to UK in application.cfm/.cfc setLocale(......); // my query set myDate = #createodbcdate(lsdateformat(thedate, 'dd-mmm-yyyy'))# // outputting #lsdateformat(myquery.myDate, 'dd/mm/yyyy')# The query thing might be a bit over kill but it never failed for me. Cheers Niklas On 26/01/06, [EMAIL PROTECTED] < [EMAIL PROTECTED]> wrote: > > >- see footer for list info -< > The dates will always be stored in ODBC format (Yank Style) as far as I > have ever found out. > Trust me this really is the best way to store them. As has already been > said store them this way and convert them locally. > > You are heading for loads of grief if you try to store the dates in any > other way. > > I spent ages trying to sort this out and the way described is DEFINATELY > the best way. > > Regards - Paul > > *********************************************************************** > The information contained within this e-mail (and any attachment) sent by > Birmingham City Council is confidential and may be legally privileged. It is > intended only for the named recipient or entity to whom it is addressed. If > you are not the intended recipient please accept our apologies and notify > the sender immediately, or telephone +(44) 121 464 4444 Unauthorised access, > use, disclosure, storage or copying is not permitted and may be unlawful. > Any e-mail including its content may be monitored and used by Birmingham > City Council for reasons of security and for monitoring internal compliance > with the office policy on staff use. E-mail blocking software may also be > used. Any views or opinions presented are solely those of the originator and > do not necessarily represent those of Birmingham City Council. We cannot > guarantee that this message or any attachment is virus free or has not been > intercepted and amended. > *********************************************************************** > _______________________________________________ > > 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 > -< > -- Niklas Richardson Prismix Ltd UK based Flex and ColdFusion Specialists _______________________________________________ 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 -<
