Re: Oracle dates and timezones

9:48 am  Mar 25, 1996      comp.databases.oracle              Note 18147 of 184
11                       Oracle dates and timezones            Resp   2 of   2
quan_at_hpcc01.corp.hp.com               Suu Quan at the HP Corporate notes server

   Seems like the Time Zone should be an intrinsic part of the DATE. Since Oracle does not do it, we -as user- will have to enforce it.

What I mean is :
every date column should be accompanied by a TZ column qualifier.

    xaction_time date,
    xaction_tz varchar(12),
    birth_date date,

    birth_tz      varchar(12),
    xxx_time      date,
    xxx_tz        varchar(12)

    Comments ? Received on Mon Mar 25 1996 - 00:00:00 CET