Database Time Adjusting

[hamhey]

OS: Solaris 8 on Intel
Database: 8.1.5
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.

Regards
Hamid

[jmodic]

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').

Use:

select to_char(sysdate, 'YYYY-MM-DD hh:MI:ss') from dual;

and everything will be back to normal...

[hamhey]

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.

Regards
Hamid

[adewri]

From the OS, so adjust your OS time