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 -> How do I get Timezone string ("07/18/64 00:00 EDT" from a DATE column?

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

From: Bob Kuhar <SPAM_ME_NOTrek_at_westol.com>
Date: 1998/02/19
Message-ID: <01bd3ce3$1f406ac0$5e564893@rek-4dx2-50-95>#1/1

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

Original text of this message

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