ORACLE将DATE转换为带有时区的TIMESTAMP(具有偏移量) [英] ORACLE Casting DATE to TIMESTAMP WITH TIME ZONE WITH OFFSET

问题描述

我需要在查询中将DATE值转换为带时区的TIMESTAMP，但是目前我正在获取EF无法使用的时区(欧洲/巴黎").

I need to cast a DATE value in a query to a TIMESTAMP WITH TIME ZONE, but currently I'm getting the TimeZone Region ('Europe / Paris') which is not valid to be used by EF.

例如，在执行此操作时:

For example, when doing this:

select CAST(FECHA AS TIMESTAMP WITH TIME ZONE) from test;

我目前得到以下输出:

07/03/14 09:22:00,000000000 EUROPE/PARIS

但是我需要像这样

07/03/14 09:22:00,000000000 +01:00

有什么想法要实现吗?

推荐答案

您可以将DATE强制转换为TIMESTAMP，然后使用

You can cast the DATE to a TIMESTAMP, then use FROM_TZ to convert this timestamp to a timestamp with time zone:

SQL> SELECT from_tz(CAST (SYSDATE AS TIMESTAMP), '+01:00') tz FROM dual;
TZ
-------------------------------------------------
07/03/14 09:47:06,000000 +01:00

这篇关于ORACLE将DATE转换为带有时区的TIMESTAMP(具有偏移量)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！