Re: clarification of timestamp

High Thomas!

Thanks for your reply.

The columns in question are radius start and end of a connection of a
custommer.

Now, it's perfectly valid that start and stop cross a DST bondary in that
case, the duration computed as (stop-start) maybe false.

What do you think?

I'm perfectly OK with leaving time sones on but the table is growing and I
need dates indexes for my statistics.

Hope I made my self clear (i.d pardon my english)

Regards,
On Mon, 29 Apr 2002, Thomas Lockhart wrote:

> > My problem was that on my 7.1.3 db, I have timestamp columns with
> > fonctinal indices as date(column).
> > Thes indices (indexes) wont work anymore because they're not marked loosy.
> > I've been told that I should go for timestamp without timezone instead,
> > witch is okay because all timezones are the same. However, what happens
> > with daylight saving calculations. Is it still take into account??
>
> No, because there is no time zone to think about. What daylight savings
> calculations would you need to consider? I'm a big believer in making
> databases time zone aware, but if everything really is happening within
> the same time zone then your application should probably not notice an
> effect.
>
> - Thomas
>

--
Olivier PRENANT Tel: +33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax)
31190 AUTERIVE +33-6-07-63-80-64 (GSM)
FRANCE Email: ohp(at)pyrenet(dot)fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)