![]() |
| |||
| Hi, I'am facing a strange behaviour of my ORACLE 9.2.0.4 server. I always get the same time back from select to_char(sysdate, ('DD.MM.YYYY HH24:MM')) ActualTime from dual; ACTUALTIME ---------------- 16.02.2005 10:02 I added seconds output to the query and the secondes will be counted correctly, but after the time 10:02:59, the time will be return to 10:02:00. After an hour the time will be set to 11:02. The Parameter fixed_date has o value. Any ideas how to get the time working again? Thanks Patrick |
![]() |
| Thread Tools | Search this Thread |
| Display Modes | |
| |