将时间戳记/日期时间从UTC转换为EST Oracle SQL [英] Convert timestamp/date time from UTC to EST Oracle SQL

问题描述

我有一个带有日期/时间值的字段，如下所示:

I have a field with a date/time value like this:

2009-11-17 18:40:05

使用UTC.在查询中如何将其转换为EST?

It's in UTC. In the query how can I convert this to EST?

我正在尝试类似的操作，但是会引发错误.

I'm trying something like this but it throws an error.

// datetime is the field name
SELECT 
   FROM_TZ(TIMESTAMP TO_DATE(datetime, 'yyyy-mm-dd hh24miss'), 'EST') AS DT
FROM
   db_name

推荐答案

我不得不对其进行一些微调，以使其在我的数据库上正常工作，但这确实可行:

I had to tweak it slightly to get it to work on my database, but this worked:

select from_tz(to_timestamp('2009-11-17 18:40:05','yyyy-mm-dd hh24:mi:ss'), 'UTC') 
at time zone 'America/New_York' from dual

关键是在时区"语法.

这篇关于将时间戳记/日期时间从UTC转换为EST Oracle SQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！