[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