티스토리 뷰

공부

[Hive] current_timestamp - INTERVAL '6' HOUR

승가비 2020. 5. 14. 01:50
728x90
SELECT 
  current_timestamp() AS current_timestamp,
  (current_timestamp() - INTERVAL '6' HOUR) AS current_timestamp_minus_six_hours

https://stackoverflow.com/questions/45242173/how-to-add-hours-to-datetime-in-zeppelin-spark-sql

 

How to add hours to Datetime in Zeppelin Spark Sql

I have a query with a column that converts the universal datetime field (not a timestamp) to a local time based on the the timezone. In Oracle I was able to do this with intervals like this snippet

stackoverflow.com

 

728x90
저작자표시 비영리

'공부' 카테고리의 다른 글

[JS] scroll go to edge  (0) 2020.05.14
[HBase] Time to Live (TTL)  (0) 2020.05.14
[Python] set locale, datetime  (0) 2020.05.14
[Spring] Class path contains multiple SLF4J bindings, exclusion library  (0) 2020.05.14
[Spring] logback.xml use spring property  (0) 2020.05.14
댓글