Convert to Local Time Issue?

[jgarciaf106]

Hi Experts,

I am trying to convert a Datetime field from a MS SQL DB on EST  to my current Timezone:

1. If I user LocalTime() Function it Shows my System has the time Zone two Hours ahead, If I user LocalTime('Central America') Shows my current time, this is the scenario I expect to happen.

2. But when I use the function ConvertToLocalTime(DB Date Time Field,'Central America') it shows the datetime like 8 hours ahead from when really happened, if Use the same function and instead of using 'Central America', I use 'UTC-02:00' I get an approximate Time, but I need to get the exact time based on my location.

Any thoughts?

Thanks in advanced

[Anil_Babu_Samineni]

Probably UTC-02:00 is not the direction correct. Can you try Central Time Zone - Wikipedia

[jgarciaf106]

Thanks, I managed this issue by getting into the DB server and found the Time Zon se was set to UTC-4.

So UTC-2 or UTC-1 are the correct timezones considering the daylight savings.