Skip to content

Instantly share code, notes, and snippets.

@asugai

asugai/gist:5b1593c43708c3a33017

Last active April 30, 2017 19:10
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 asugai/5b1593c43708c3a33017 to your computer and use it in GitHub Desktop.
Save asugai/5b1593c43708c3a33017 to your computer and use it in GitHub Desktop.
Download ZIP
Twitter `created_at` to Mysql a unix timestamp
Raw
gistfile1.txt
UNIX_TIMESTAMP(STR_TO_DATE(`created_at`, '%a %b %d %H:%i:%s +0000 %Y'))
Changes "Mon Nov 10 21:14:41 +0000 2014" to "1415654081"
@wonderer007
Copy link

Thanks a lot @asugai you save my day

@asugai
Copy link
Author

asugai commented Apr 30, 2017

Glad this helped!

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