Skip to content

Instantly share code, notes, and snippets.

@gavinblair

gavinblair/date.sql

Created September 1, 2010 16:03
Show Gist options
  • Save gavinblair/560920 to your computer and use it in GitHub Desktop.
Save gavinblair/560920 to your computer and use it in GitHub Desktop.
Download ZIP
Convert timestamp to readable date right in MySQL
Raw
date.sql
SELECT date_format(FROM_UNIXTIME(u.access), '%Y %M %D') FROM users u ORDER by u.access DESC;
@gavinblair
Copy link
Author

Formatting instructions: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment