开发者

Time not updatating when using sysdate Oracle on Windows

开发者 https://www.devze.com 2023-01-11 12:48 出处:网络
Not sure what causes that problem, but when I run query select to_char(sysdate, \'HH24:MM\') from dual;

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.

0

精彩评论

暂无评论...
验证码 换一张
取 消