SQL Language (MOSC)

MOSC Banner

Chilean DTS issues

edited Jan 20, 2016 10:03AM in SQL Language (MOSC) 1 commentAnswered

Hi. I'm dealing with Chilean DTS issues. Since January, 2015, Chile decided not no apply DST, so they'll stay the whole year on UTC-3.I've applied Version25 FileTime with updated information about it.Anyway, when I perform a select of an old date cannot get the correct value.

Data for 10/08/1999 is incorrect. It should be 04:29:00.

If I change the date of DB server and perform the query...it works well

Can anyone help me?

Thanks in advance

SELECT hora,

       CAST(hora AS TIMESTAMP) AT TIME ZONE 'Chile/Continental' AHORA_EN_CHILE,

       hora_timestamp AT TIME ZONE 'Chile/Continental'

  from prueba_horas;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center