European time zone when converting ldap field

[ingridmerx]

In my load script I converted an LDAP field, but it shows the UTC time. To be in European (Amsterdam) time it should be minus one hour. What is the best way to achieve this?

I used:

timestamp(left(lastLogon,11)/86400-109205)

[ingridmerx · Accepted solution]

Found out myself :

timestamp((left(lastLogon,11)/86400-109205)+time#('01:00:00','hh:mm:ss'),'YYYY-MM-DD hh:mm:ss') as ADLastlogon