timestamp_func.result 672 Bytes
Newer Older
1
** Connecting con1 using root **
2 3 4 5 6 7 8 9 10 11 12 13 14 15
SELECT date(now()) = date(sysdate());
date(now()) = date(sysdate())
1
SET @@session.timestamp = 1100000000;
SELECT date(now()) != date(sysdate());
date(now()) != date(sysdate())
1
** Connecting con0 using root **
SELECT @@session.timestamp != 1100000000;
@@session.timestamp != 1100000000
1
SET @@session.timestamp = 1000000000;
SELECT date(now()) != date(sysdate());
date(now()) != date(sysdate())
16 17
1
** Connection con1 **
18 19
SELECT @@session.timestamp != 1000000000;
@@session.timestamp != 1000000000
20
1
21 22
SELECT @@session.timestamp = 1100000000;
@@session.timestamp = 1100000000
23 24 25
1
** Connection default **
Disconnecting Connections con0, con1