Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do I get Timezone string ("07/18/64 00:00 EDT" from a DATE column?

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

From: <bob_kuhar_at_ccmail.sgo.sony.com>
Date: 1998/02/19
Message-ID: <6ch57v$r8u$1@nnrp1.dejanews.com>#1/1

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

This message: [ Message body ]
Next message: Kevin P. Fleming: "Re: How do I get Timezone string ("07/18/64 00:00 EDT" from a DATE column?"
Previous message: Rick Slingwine: "Re: How do I get Timezone string ("07/18/64 00:00 EDT" from a DATE column?"
In reply to: Rick Slingwine: "Re: How do I get Timezone string ("07/18/64 00:00 EDT" from a DATE column?"
Next in thread: Kevin P. Fleming: "Re: How do I get Timezone string ("07/18/64 00:00 EDT" from a DATE column?"
Reply: Kevin P. Fleming: "Re: How do I get Timezone string ("07/18/64 00:00 EDT" from a DATE column?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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