Forum OpenACS Q&A: Response to Accessing the system clock

Collapse
4: Response to Accessing the system clock (response to 1)
Posted by Brian Fenton on 10/04/02 11:03 AM
If I wanted to keep consistent times, I would you use my database as my clock.

In Oracle, you use the following:
select to_char(sysdate,'hh24:mi') as current_time from dual;

Related tip from bad experience: never change the OS time when the database is up. Ouch!