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

From: Rick Slingwine <_at_mitec.net>
Date: 1998/02/18
Message-ID: <6cgasv$b8$1@usenet88.supernews.com>#1/1

Lookup the to_char Oracle function. You can get just about any date format you can imagine.

Rick.

Bob Kuhar wrote in message <01bd3ce3$1f406ac0$5e564893_at_rek-4dx2-50-95>...
>I am but a lowly PowerBuilder developer hoping that the Oracle masters can
>enlighten me. The problem is this, PB Clients can't display Timezone info
>in their DateTime fields. No way. No how. PB has failed, but I am
>hopeful that Oracle Stored Procedures or Functions or something can provide
>me with the Date/Time string of my dreams. All I want from my SELECTs of
>DATE columns is a string of the format DD/MM/YYYY HH:MI TZ (Ex. "07/18/1964
>00:00:00 EDT"). Has anyone else ever required Timezone from their Oracle
>7.2 DATE fields?
>
>Thanks in advance.
>Bob
Received on Wed Feb 18 1998 - 00:00:00 CST