What MySQL will return on adding microseconds in the timestamp value for converting it into an integer?

As we know that the value of timestamp can be converted to a number of seconds with the help of UNIX_TIMESTAMP() function. MySQL would ignore the microseconds added to the value of timestamp because the value of UNIX_TIMESTAMP is only 10digits long.

Example

mysql> SELECT UNIX_TIMESTAMP('2017-10-22 04:05:36')AS 'Total Number of Seconds';
+-------------------------+
| Total Number of Seconds |
+-------------------------+
| 1508625336              |
+-------------------------+
1 row in set (0.00 sec)

mysql> SELECT UNIX_TIMESTAMP('2017-10-22 04:05:36.200000')AS 'Total Number of Seconds';
+-------------------------+
| Total Number of Seconds |
+-------------------------+
| 1508625336              |
+-------------------------+
1 row in set (0.00 sec)

The queries above shows that the output remains same even after adding the 6 digits value of microseconds.

Seetha

Published on 19-Feb-2018 11:26:27

• Related Questions & Answers
• On passing an out-of-range value in UNIX_TIMESTAMP() or FROM_UNIXTIME() function, what MySQL will return?
• Python Pandas - Return the microseconds from Timedelta object using integer input
• What will MySQL CHAR_LENGTH() function return if I provide NULL to it?
• Python Pandas - Return the microseconds from Timedelta object
• Searching for an integer value in a varchar field in MySQL?
• Adding an element into the Hashtable in C#
• Return the nearest greater integer of the decimal number it is being called on in JavaScript
• Adding the specified key and value into HybridDictionary in C#
• Reorder integer except for value 0 with MySQL?
• Adding binary without converting in JavaScript
• Convert DATE timestamp to return only the month name in MySQL
• What is the maximum possible value of an integer in C# ?
• What is the maximum possible value of an integer in Python?
• What is the maximum possible value of an integer in Java ?
• Python Pandas - Return the microseconds from Timedelta object using string input