Time not updatating when using sysdate Oracle on Windows
Not sure what causes that problem, but when I run query
select to_char(sysdate, 'HH24:MM') from dual;
I constantly get the same time 15:开发者_开发知识库08. I even check a different Oracle DBMS on different machine (also Windows) and got the same result.
HH24:MM is giving you the hours (HH) in 24-hour format, and the Month (August, 08).
You probably meant to type HH24:MI... ;)
MM
is the code for month. You want MI
for minute.
精彩评论