>- see footer for list info -<
As a follow up to this, I've got a time_zone table now in place, with plenty of
lovely fields and lots of data. However...
One of the fields is "tz_dst_starts", a date field that stores (surprise,
surprise) the datetime when DST kicks in for each TZ (if applicable).
Retrieving "27/03/2005 01:00:00" from the db (the datetime when GBs DST begins)
is converted by ColdFusion (or Java?) to "27/03/2005 02:00:00".
Is CF/Java trying to be helpful and preventing me from creating an invalid
datetime, given it's knowledge of the DST rules for the timezone in which the
server is running?
To prove that this is so:
<cfset dt = createDateTime(2005, 3, 27, 1, 0, 0)>
<cfoutput>#dt#</cfoutput>
outputs
{ts '2005-03-27 02:00:00'}
Presumably there's a way of doing this that works "with the grain"...
If I can't create that datetime, perhaps I should just kludge the values
*shudder* to say that DST starts an hour later?
Or should I try using java.util.TimeZone instead of my own TimeZone.cfc?
Any "best practise" thoughts very welcome...
--
Aidan Whitehall
Macromedia ColdFusion Developer
________________________________________________________________________
This e-mail has been scanned for all viruses by Star. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
_______________________________________________
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 -<
