On 11/10/06, Richard Wesley <hawkfish@...> wrote:

>
> 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.

I am doing stuff to do with local people time rather than UTC