开发者

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.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜