oracle中日期国际化转换函数

在ORACLE中一般采用TimeStamp With Time Zone类型来存放国际化格式的日期,为方便它与字符串类型的转换,写了如下函数: 

TimeStamp With Time Zone -> 字符串

create or replace
function conv_tsz_str
( tszDateTime in TimeStamp With Time Zone, areaCode in varchar2
) return varchar2 as
begin
  return TO_CHAR(tszDateTime AT TIME ZONE areaCode,'YYYY/MM/DD HH24:MI:SS');
end conv_tsz_str;

 

字符串 -> TimeStamp With Time Zone

create or replace
function conv_str_tsz
( strDateTime in varchar2
) return TimeStamp With Time Zone as
begin 
  return TO_TIMESTAMP_TZ(strDateTime,'YYYY/MM/DD HH24:MI:SS (TZR,TZD)');
end conv_str_tsz;

说明:strDateTime 中可以包括地区代码,如'2008/08/08 10:00:00 PRC'