Skip to content

Instantly share code, notes, and snippets.

@parzibyte

parzibyte/7.sql Secret

Created December 29, 2020 03:02
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 parzibyte/7ef1b68047a3aa48d418e4ec4b231d7b to your computer and use it in GitHub Desktop.
Save parzibyte/7ef1b68047a3aa48d418e4ec4b231d7b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
7.sql
# Usando WHERE mostrar todos los registros que se encuentren entre las fechas 2020-12-23 20:40:07 y 2020-12-24 08:45:00
SELECT date, temperature, humidity
FROM dht_log
WHERE date >= "2020-12-23 20:40:07"
AND date <= "2020-12-24 08:45:00";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment