[Phoenix] 시간 관련 API 예제
DATE 타입 값에 대해서 where.. between을 사용하려면 TO_TIMESTAMP를 사용한다
where service_tag = 'google_plus' and log_time between TO_TIMESTAMP('2017-12-19 10:00:24.000') and TO_TIMESTAMP('2017-12-19 10:05:24.000') order by timestamp
https://phoenix.apache.org/language/functions.html#to_timestamp
current_time()과 now()의 결과는 동일하다.
> select current_time();
+---------------------------------+
| TIME '2017-12-19 03:05:53.873' |
+---------------------------------+
| 2017-12-19 03:05:53.873 |
+---------------------------------+
1 row selected (0.006 seconds)
> select now();
+---------------------------------+
| DATE '2017-12-19 03:05:56.345' |
+---------------------------------+
| 2017-12-19 03:05:56.345 |
+---------------------------------+
1분전, 2분전 결과를 보고 싶다면 다음 결과를 확인한다.
> select now(), now() - (1.0 / (60 * 24));
+---------------------------------+---------------------------------+
| DATE '2017-12-19 03:10:39.428' | DATE '2017-12-19 03:09:39.429' |
+---------------------------------+---------------------------------+
| 2017-12-19 03:10:39.428 | 2017-12-19 03:09:39.429 |
+---------------------------------+---------------------------------+
1 row selected (0.005 seconds)
> select now(), now() - (2.0 / (60 * 24));
+---------------------------------+---------------------------------+
| DATE '2017-12-19 03:10:42.772' | DATE '2017-12-19 03:08:42.772' |
+---------------------------------+---------------------------------+
| 2017-12-19 03:10:42.772 | 2017-12-19 03:08:42.772 |
+---------------------------------+---------------------------------+
시간과 날짜 함수는 다음과 같이 지원한다.
Time and Date Functions
| TO_DATE TO_TIME TO_TIMESTAMP CURRENT_TIME CONVERT_TZ TIMEZONE_OFFSET | NOW YEAR MONTH WEEK DAYOFYEAR DAYOFMONTH | DAYOFWEEK HOUR MINUTE SECOND |