You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

OTM: Time zone of Rate Record Effective Date

Summary:

What time zone is used to store the Rate Record Effective Date?

Content (please ensure you mask any confidential information):

When I enter an Effective Date of 2025-01-02 in a Rate Record, in the OTM database it is saved as 2025-01-02 08:00:00

Is there any way to control this 8 hour offset? As this date is not related to any location, I was expecting the timezone to be UTC. In my Preferences, the time zone is GMT+1 (CET)

select rate_geo_xid, EFFECTIVE_DATE, expiration_date from rate_geo where rate_geo_xid= 'RR_0209_TRP_TL_250101_CARVIN-FR_091_MAG'

RATE_GEO_XID

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!