Skip to content

Instantly share code, notes, and snippets.

@doryokujin

doryokujin/td_time_range.sql

Last active April 23, 2019 08:14
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 doryokujin/0814a086c59e5e21da3b to your computer and use it in GitHub Desktop.
Save doryokujin/0814a086c59e5e21da3b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
td_time_range.sql
boolean TD_TIME_RANGE(int/long unix_timestamp, int/long/string start_time, int/long/string end_time [, string default_timezone = 'UTC'])
-- （例）2013年のデータを取得
SELECT ... WHERE TD_TIME_RANGE(time, "2013-01-01 JST", "2014-01-01 JST")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment