Hi all,
Suppose of some reason you would like to change the time oracle database,
1. Do you know how to change the and time of database.
2. And how to change the format of sysdate reporting Hard code in the database. You can use:
select to_char(sysdate, 'YYYY-MM-DD hh:min:ss') from sysdate;
How can change the time format of database to get the time of database as the answer to above query from sysdate.

Thanks Hamid