Convert Text Datetime of format YYYY-MM-DDThh:mm:ss.000Z to SAS Datetime

vfarmak — Wed, 09 Dec 2020 21:13:28 GMT

Greetings Everyone!

I have the following question:

I have date stored in a character format (24) and I want to convert it to a datetime format.

The date is stored in this type of format

2020-12-03T14:00:00.000Z

I tried Input(<field>, datetime24.) with no luck.

As an example I have the following row:

ID	Date
000000039	2020-11-04T08:30:00.000Z

Any help is appreciated.

Thank you in advance,

Re: Convert Text Datetime of format YYYY-MM-DDThh:mm:ss.000Z to SAS Datetime

ballardw — Wed, 09 Dec 2020 21:22:06 GMT

data example;
   charvar ="2020-11-04T08:30:00.000Z";
   dt = input(charvar,e8601dz.) ;
   format dt datetime18.;
run;