Re: current_timestamp() freezes
Posted by: Rick James
Date: November 30, 2015 08:20PM

Can't dup:

> SELECT current_timestamp(); SELECT SLEEP(5); SELECT current_timestamp();
+---------------------+
| current_timestamp() |
+---------------------+
| 2015-11-30 18:17:13 |
+---------------------+
1 row in set (0.00 sec)

+----------+
| SLEEP(5) |
+----------+
|        0 |
+----------+
1 row in set (5.02 sec)

+---------------------+
| current_timestamp() |
+---------------------+
| 2015-11-30 18:17:18 |   <--- looks different to me.
+---------------------+
1 row in set (0.00 sec)

Please provide context (what tool is running it), SELECT statement, and anything else that might shed light.

Options: ReplyQuote


Subject
Written By
Posted
November 17, 2015 05:44AM
November 18, 2015 04:27AM
Re: current_timestamp() freezes
November 30, 2015 08:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.