What is the use of MySQL FROM_UNIXTIME() function?

MySQL FROM_UNIXTIME() function is used to return the date/datetime from a version of Unix timestamp. The format of return value would be either ‘YYYY-MM-DD HH:MM:SS’ or ‘YYYYMMDDHHMMSS.uuuuuu’ depending upon the context of the function i.e. whether the context is numeric or string.

Following is the syntax for FROM_UNIXTIME −

FROM_UNIXTIME(unix_timestamp, [format])

Here unix_timestamp is the value of Unix timestamp and format includes the format string in which we want to return the value.

Example

mysql> Select FROM_UNIXTIME(1555033470);
+---------------------------+
| FROM_UNIXTIME(1555033470) |
+---------------------------+
| 2019-04-12 07:14:30       |
+---------------------------+
1 row in set (0.00 sec)

Varma

Published on 19-Feb-2018 11:40:49

• Related Questions & Answers
• What is the use of MySQL GET_FORMAT() function?
• What is the use of MySQL LAST_INSERT_ID() function?
• What is the use of MySQL CONCAT_WS() function?
• What is the use of MySQL TRUNCATE() function?
• What is the use of MySQL UNHEX() function?
• What is the use of MySQL SUBSTRING_INDEX() function?
• What is the use of MySQL CHAR() function?
• What is the use of FIND_IN_SET () function in MySQL?
• What is the use of LOCATE() function in MySQL?
• In MySQL, how can we use FROM_UNIXTIME() function with format string?
• What is the use of MySQL NULLIF() control flow function?
• What is the use of MySQL IFNULL() control flow function?
• How to use MySQL FROM_UNIXTIME() function to return datetime value in numeric format?
• What is the use of JavaScript eval function?
• What is the use of apply() function in JavaScript?