Chilean DTS issues
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;