Re: format date with Oracle Dynamic SQL
From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Tue, 1 Mar 2005 18:53:20 -0800
Message-ID: <ULadnXqd1NXjt7jfRVn-iw_at_comcast.com>
Date: Tue, 1 Mar 2005 18:53:20 -0800
Message-ID: <ULadnXqd1NXjt7jfRVn-iw_at_comcast.com>
<deadlocklegend_at_gmail.com> wrote in message
news: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
get rid of the to_date. Doesn't ProC have a native date interface?
Wouldn't it make more sence to use that?
Jim
>
Received on Wed Mar 02 2005 - 03:53:20 CET