Everybody is good, I met a implementation of oracle sysdate returns time is not the right questions, oracle is from the official image created by the container
Symptoms are as follows:
At 9 a.m. more minutes to perform select to_char (sysdate, 'yyyy - MM - dd HH24: MM: ss ") from dual;
According to the 2019-07-26 09:07:01
Execute the statement, only the last seconds, in front of date don't walk about in
Wait for ten more minutes and executed according to the 2019-07-26 10:07:01 also perform, behind only the number of seconds in go,

Now it seems as if only minutes has been 07, who met this kind of circumstance to have excuse me?

CodePudding user response:

Grammar to write wrong, is "mi" rather than "mm" mm is in, is, of course, 07,

select to_char(sysdate,'yyyy-MM-dd HH24:mi:ss') from dual;

CodePudding user response:

The first is "mm" but "mi", then you also need to change the docker time time zones,

Under reference these few document:
Oracle Database on Docker "Best Practices"
"Oracle11g on docker for Windows 10"
"On the Docker build Oracle 11 g DG"