Re: How do I get Timezone string ("07/18/64 00:00 EDT" from a DATE column?

From: Kevin P. Fleming <kfleming_at_access-laserpress.com>
Date: 1998/02/19
Message-ID: <34EC6B4C.94C41D7F@access-laserpress.com>#1/1

Where is this timezone supposed to come from? The DATE column has no storage of the timezone at all; as far as I'm aware the column actually stores the date/time in GMT.

bob_kuhar_at_ccmail.sgo.sony.com wrote:
>
> In article <6cgasv$b8$1_at_usenet88.supernews.com>,
> "Rick Slingwine" <@mitec.net> wrote:
> >
> > Lookup the to_char Oracle function. You can get just about any date format
> > you can imagine.
> >
> > Rick.
> >
>
> I've been to the TO_CHAR() documentation and it shows no indication of how to
> get Timezone (EST/EDT) as part of the DATE format. I was hoping someone had
> a canned procedure or a 3rd Party Library. Thanks for the reply, though.
>
> bob
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Thu Feb 19 1998 - 00:00:00 CST