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@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 Tue Mar 01 2005 - 20:53:20 CST