I have a table name db,it's struct is follows:
SYS_DATE DATE
It contains a value "2004-7-31 15:41:48"

Then I want to show it,I use follow statement:
select to_char(sys_date,'YYYY-MM-DD HH:MM:SS') from db

But result is "2004-7-31 03:41:48",not "2004-7-31 15:41:48"
How to make result is "2004-7-31 15:41:48"?

Thanks in advance!

Hi Edward,
 Try using,
   select to_char(sys_date,'YYYY-MM-DD HH24:MM:SS') from db;
 HH24 will show the time in 24 Hour format.


Amol.

Amol N. Kataria