DST Configuration Does Not Affect To UtcConvert() Function (Doc ID 2688158.1)

Last updated on SEPTEMBER 17, 2021

Applies to:

Goal

DST Configuration does not affect to UtcConvert() function

In Vanilla Siebel Time Zone Configuration under Application - Data -> Time Zone Administration for New Zealand i.e. "New Zealand Standard Time" (GMT+12:00) Auckland, Wellington,
There are 3 records under Details for DST,

1/01/2010 0:00 720 60 Last Sunday September 120 First Sunday April 180
1/01/2007 0:00 720 60 First Sunday October 120 Third Sunday March 120
1/01/1900 0:00 720 60 First Sunday October 120 Third Sunday March 120


Created the following calculated field and confirmed the display.
  Syntax calc field is using :
  UtcConvert([As Of Date],"(GMT+12:00) Auckland,Wellington")

  Input Field value:
  31/03/2007 13:35:41

  Actual output of function:
  03/31/2007 00:35:41

  Expected output:
  31/03/2007 13:35:41

Please change the Start Date of Admin Time Zone from "1/01/2007" to "6/07/2007" so that the UtcConvert() function returns the expected value. After making the changes, restart Siebel Server.

1/01/2010 0:00 720 60 Last Sunday September 120 First Sunday April 180
6/07/2007 0:00 720 60 First Sunday October 120 Third Sunday March 120
1/01/1900 0:00 720 60 First Sunday October 120 Third Sunday March 120

  Input Field value:
  3/31/2007 01:35 PM

  Output of function after changing Start Date:
  03/31/2007 01:35:00
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.