Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> date format
I have a table which contains a column date_operation declare as date
when I do sql as "select date_operation" from a_table, I got as below:
02-MAR-05
In fact the date_operation data is like "02-MAR-05 12:20:00", contains
hour:minute:second
I know I can use to_char() to format the date output, but how do I make
output
as "02-MAR-05 12:20:00" without using to_char() process.
Thanks. Received on Thu Jan 05 2006 - 07:01:51 CST