Mysql Unix-Timestamp Date Format
10,522
select date_format(from_unixtime(1264105904),'%b %d, %Y %l:%i %p PDT');
should do what you want
Author by
Umut Derbentoğlu
Updated on June 11, 2022Comments
-
Umut Derbentoğlu almost 2 years
In mysql database I store date column as unix-timestamp format (for example:
1264105904
). I want to convert this date to datetime like"Oct 11, 2011 6:25 am PDT"
in select statement. How can I achieve this?