asugai/gist:5b1593c43708c3a33017

Last active April 30, 2017 19:10

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/asugai/5b1593c43708c3a33017.js"></script>
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 commented Jan 14, 2017

Thanks a lot @asugai you save my day

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