Answers for "mysql convert unix timestamp to datetime"

mysql date format unix timestamp

SELECT
  FROM_UNIXTIME(timestamp) 
FROM 
  your_table;

Posted by: Guest on September-22-2020

sql convert unix time to date

select FROM_UNIXTIME(UNIX_TIMESTAMP(),'%a %b %d %H:%i:%s UTC %Y');

Posted by: Guest on July-16-2020

Code answers related to "mysql convert unix timestamp to datetime"