Database Time Adjusting
OS: Solaris 8 on Intel
The time reported by using date command is
about 30 minutes differnet from databse time using
select to_char(sysdate, 'YYYY-MM-DD hh:mm:ss') from dual;
How can adjust the time of database.
No need to adjust anything in the database - it's your format mask that's causing you funky time results. Format mask 'mm' (like 'MM') is for MONTHS, not for MINUTES as you used it. Minutes are denoted with 'MI' (or 'mi').
select to_char(sysdate, 'YYYY-MM-DD hh:MI:ss') from dual;
and everything will be back to normal...
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Thanks for the answere,
One guestion is still in my mind:
Where the databse get the time and how can we adjust the time if we need.
From the OS, so adjust your OS time
"There is a difference between knowing the path and walking the path."
Click Here to Expand Forum to Full Width