format date with Oracle Dynamic SQL
From: <deadlocklegend_at_gmail.com>
Date: 1 Mar 2005 09:52:41 -0800
Message-ID: <1109699561.490251.26680_at_z14g2000cwz.googlegroups.com>
Hi all,
Date: 1 Mar 2005 09:52:41 -0800
Message-ID: <1109699561.490251.26680_at_z14g2000cwz.googlegroups.com>
Hi all,
when i set a date field's type (12) to VARCHAR2 or STRING, I get the date (mm/dd/yyyy) correct, but I can never get the time which is always set to 00:00:00 even if i increase the buffer size? Is there anyway to force pro*c to format correctly without using to_char because with to_char i lose the ability to keep track of correct data type.
Thanks Received on Tue Mar 01 2005 - 18:52:41 CET