Select year from a Unix timestamp in MySQL
Question:
How to select year from a Unix timestamp in MySQL? Answer:
SELECT FROM_UNIXTIME(event_time, '%Y') AS year FROM events;
Description:
If a MySQL database table has a Unix timestamp stored in an INT
field, it must first be converted to an easy-to-read format when generating a report.
This conversion can be done with the FROM_UNIXTIME()
function, which returns a representation of unix_timestamp as a DateTime or character string value.
If you want to refine this further, for example, if you only need the year value, you can use the '%Y
' format string as a second parameter.
Reference:
The from_unixtime reference
Share "How to select year from a Unix timestamp in MySQL?"
Related snippets:
- Convert Unix timestamp to human readable date in MySQL
- Count total rows by year in MySQL
- Convert INT to DATETIME in MySQL
- Select year from a Unix timestamp in MySQL
- Group by year of Unix timestamp in MySQL
- Extract year from a date in MySQL
- Get current date in MySQL
- Get current year in MySQL
- Get last 30 days records in MySQL
Tags:
mysql, select, timestamp, year, int, integer, year from timestamp, unix timestamp Technical term:
Select year from a Unix timestamp in MySQL