Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: format date with Oracle Dynamic SQL

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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US