Problem With Daylight Time Saving In Pipeline (Doc ID 1464311.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 to 7.3.0.0.0 [Release 7.3.0]
Information in this document applies to any platform.
***Checked for relevance on 20-JAN-2015***

Goal

The function AscDateUnix does not return the correct timestamp in an output file.

The time zone is Europe/Paris and configured the UTC_OFFSET to +0100.

Put into pipeline a CDR with start date at 06/01/2011 00:00:00 and end date at 12/01/2011 00:00:00 (in the input file). In the output file configure to write 4 fields (start and end date and the start and end date as tilmestamps). But, the timestamps are wrong: it have 1322697600 and 1306886400 instead of 1322694000 and 1306879200.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms