I am having trouble converting the following time stamps:
2021-12-30T17:07:54:045Z
2021-12-28T21:29:04:199Z
Into Mountain Standard Time.
I have been trying to use the DATEPARSE function as follows without any luck:
DATEPARSE('yyyy-MM-dd HH.mm.ss.SSS', [Createdat])
Any help would be appreciated.
Thanks,
14 answers
@Brian Rohde
You almost had it correct, this works :
DATEPARSE('yyyy-MM-dd HH:mm:ss:SSS', replace(replace([Createdat],'T',' '),'Z',''))
