Skip to content

Instantly share code, notes, and snippets.

@bleft

bleft/MySQL.sql

Last active November 12, 2019 12:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bleft/435cb08344667bbddd21400ae6379cb7 to your computer and use it in GitHub Desktop.
Save bleft/435cb08344667bbddd21400ae6379cb7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
MySQL.sql
SELECT DATE_FORMAT(FROM_UNIXTIME(`date`), '%e %b %Y %H:%m:%s') AS created, temp, humid FROM `table_name` ORDER BY id DESC LIMIT 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment