Skip to content

Instantly share code, notes, and snippets.

@gavinblair

gavinblair/date.sql

Created September 1, 2010 16:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save gavinblair/560920 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
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

gavinblair commented Sep 1, 2010

Copy link
Copy Markdown
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