On Oct 6, 2006, at 03:40, Nick Upson wrote:

> has anyone written a routine that will give access to the daylight
> saving value in the standard time structure. I need to know, for a
> given date & time and current timezone, if DST applies so that I can
> calculate:
>
> how many minutes it is
> date & time it starts
> date & time it ends

Isn't this a presentation layer issue?

Unless you are doing something very unusual (e.g. tracking spending
habits by local time of day) times in a database should be UTC.
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
(w) +1-206-633-3400x505 hawkfish
tableausoftware com
http://www.tableausoftware.com/