albang/range_horaire_sql

Created December 26, 2013 11:03

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

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/albang/8132331.js"></script>
Save albang/8132331 to your computer and use it in GitHub Desktop.

Download ZIP

Utiliser des ranges horaires sur mysql avec un timestamp!

Raw

range_horaire_sql

SELECT * FROM nomDeLaTable WHERE FROM_UNIXTIME(timestamp,'%H') >= '18' AND FROM_UNIXTIME(timestamp, '%H') < '20'

Author

albang commented Dec 26, 2013

source http://notes.maxy.fr/selection-en-fonction-dune-plage-horaire-avec-des-timestamp-en-mysql.html

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