Skip to content
Related Articles

Related Articles

Improve Article
FROM_UNIXTIME() function in MySQL
  • Last Updated : 22 Dec, 2020

FROM_UNIXTIME() :
This function in MySQL helps to return date /DateTime representation of a Unix timestamp. The format of returning value will be ‘YYYY-MM-DD HH:MM:SS’ or ‘YYYYMMDDHHMMSS’, depending on the context of the function.

Syntax :

FROM_UNIXTIME(unix_timestamp, format)

Parameters :
The function can accept two arguments as follows.

  • unix_timestamp –
    It is an internal timestamp value and it’s value can be produced by UNIX_TIMESTAMP() function.
  • format –
    The way in which the resulting value will be formatted

Result :
The function will return date /DateTime representation of a Unix timestamp. And the format of returning value will be ‘YYYY-MM-DD HH:MM:SS’ or ‘YYYYMMDDHHMMSS’, depending on the context of the function.

Example-1 :
Working of FROM_UNIXTIME() function with one parameter.



SELECT FROM_UNIXTIME(599462400) 
AS Unix;

Output :

Unix

1988-12-29 22:20:00

Example-2 :
Working of FROM_UNIXTIME() function with fractional seconds.

SELECT FROM_UNIXTIME(599462445.99999) 
AS Unix;

Output :

Unix

1988-12-29 22:20:45.99999

Example-3 :
Working of FROM_UNIXTIME() function when both parameters are passed.

  • When format is ‘%W, %D %M %Y’ –
    SELECT FROM_UNIXTIME(799462445, '%W, %D %M %Y') 
    AS Unix;

    Output :

    Unix

    Tuesday, 2nd May 1995
  • When format is ‘%h:%i %p, %D %M %Y’ –
    SELECT FROM_UNIXTIME(799462445, '%h:%i %p, %D %M %Y') 
    AS Unix;

    Output :

    Unix

    06:54 PM, 2nd May 1995

Example-4 :
Working of FROM_UNIXTIME() function in Numeric context.

SELECT  
FROM_UNIXTIME(846562400) As 'String_form',
FROM_UNIXTIME(846562400) + 1 As 'Numeric_form';

Output :

String_formNumeric_form
1996-10-28 21:13:2019961028211321
My Personal Notes arrow_drop_up
Recommended Articles
Page :