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

Last time I checked Rick, about 30 seconds ago, Oracle does not include a TimeZone part in a date field.

Bob, I'd suggest storing the timezone as a varchar2 string and then concatenating your formated date string with it.

Rick Slingwine wrote:
>
> 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 Thu Feb 19 1998 - 00:00:00 CST