Got it. Here the syntax to make it work select ContactHelper, datetime(StartDate/10000000-62135596800,'unixepoch') as Start, datetime(EndDate/10000000-62135596800,'unixepoch') as End from appointment Thanks to Michael Black (IS) for helping me. please note ContactHelper, StartDate, EndDate...