Convertolocaltime returning wrong time of the day

[didierodayo]

Hello,

I don;t think this script is working properly. any ideas why it is returning pm instead of AM?

ConvertToLocalTime(Timestamp(Now()),'GMT+02:00')

Right now I know it is AM in Paris for example.

Thanks

[techvarun]

Try Below Code:

TEST:
Load * Inline [
DateField
22-10-2017 11:00:43
];

LOAD *, ConvertToLocalTime(timestamp(DateField - maketime(5,30)), 'GMT+02:00') as Paris Resident TEST;
Drop Table TEST;

I am using maketime(5,30)) since i currently fall on GMT+05:30 timezone you might need to adjust the maketime depends on your operating system settings.

Thanks

[didierodayo]

Hi Varun,

am in GMT +  11:00  so if I understand correctly we my script should be?

ConvertToLocalTime(timestamp(DateField - maketime(11)), 'GMT+02:00')

?

Thanks

[techvarun · Accepted solution]

Yes, Correct.

try and let us know the result

Thanks,

Varun

[didierodayo]

Thanks Varun, I have tested with my data and it worked.