Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle datatype DATE and time zone

Re: Oracle datatype DATE and time zone

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 23 Dec 2004 17:34:17 -0800
Message-ID: <1103852057.643449.154450@c13g2000cwb.googlegroups.com> 





Why do you want/need to adjust for the timezone?  Depending on your
answer besides the timestamp with time zone datatype you might be able
to use a date datatype with a column to indicate the time zone, or to
use a before insert/update trigger to modify the date value for the
timezone offset.



HTH -- Mark D Powell --
Received on Thu Dec 23 2004 - 19:34:17 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US