Re: format date with Oracle Dynamic SQL
From: <deadlocklegend_at_gmail.com>
Date: 1 Mar 2005 18:46:20 -0800
Message-ID: <1109731580.120769.164910_at_g14g2000cwa.googlegroups.com>
Date: 1 Mar 2005 18:46:20 -0800
Message-ID: <1109731580.120769.164910_at_g14g2000cwa.googlegroups.com>
sorry about bothering you, but when i do something like
select to_date(to_char(date_column, 'yyyy-mm-dd hh24:mi:ss'),
'yyyy-mm-dd hh24:mi:ss') from table_name
in my pro*c code, i get back
2005-02-24 00:00:00
when data is 2005-02-24 11:05:07