How to convert timestamp to datetime in MySQL

Question

How to convert 1300464000 to 2011-03-18 16 00 00 in MySQL

User · Accepted Answer

Use the FROM UNIXTIME   function in MySQL  Remember that if you are using a framework that stores it in milliseconds  for example Java s timestamp  you have to divide by 1000 to obtain the right Unix time in seconds

User · Answer

To answer Janus Troelsen comment  Use UNIX TIMESTAMP instead of TIMESTAMP  SELECT from unixtime  UNIX TIMESTAMP    2011-12-01 22 01 23 048        The TIMESTAMP function returns a Date or a DateTime and not a timestamp  while UNIX TIMESTAMP returns a unix timestamp

User · Answer

SELECT from unixtime  UNIX TIMESTAMP fild with timestamp    from  your table  This work for me

User · Answer

DATE FORMAT FROM UNIXTIME  orderdate      Y- m- d  H  i  s   as  Date  FROM  orders    This is the ultimate solution if the given date is in encoded format like 1300464000

User · Answer

You can use   select from unixtime 1300464000   Y- m- d  h  i  s   from table    For in details description about   from unixtime   unix timestamp

[mysql] How to convert timestamp to datetime in MySQL?

Examples related to mysql