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_at_rek-4dx2-50-95>#1/1
Date: 1998/02/19
Message-ID: <01bd3ce3$1f406ac0$5e564893_at_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 CET