티스토리 뷰

공부

[Hive] current_timestamp - INTERVAL '6' HOUR

seunggabi 승가비 2020. 5. 14. 01:50
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

 

댓글
댓글쓰기 폼