date format

From: blackdog <cljlk_at_hotmail.com>
Date: 5 Jan 2006 05:01:51 -0800
Message-ID: <1136465397.129048.139350@g14g2000cwa.googlegroups.com>

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