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: Update column - Timestamp with time zone

Re: Update column - Timestamp with time zone

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 25 Jul 2007 16:52:31 -0700
Message-ID: <1185407551.635053.50000@z24g2000prh.googlegroups.com>


On Jul 25, 3:27 pm, Jeremy Smith <godto..._at_hotmail.com> wrote:
> We have a table with a colum that is Timestamp(6) with time zone.
>
> Developer has request that all records with a time zone of EST be
> update to US/Michigan.
>
> What is the best why to make the update to every record?
>
> thanks

Michigan is in the Eastern time zone so what is it the developer actually wants to display the time as? Is he or she concerned about Daylight Saving Time or something?

Received on Wed Jul 25 2007 - 18:52:31 CDT

Original text of this message

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