Formatting date

[Pandu2]

Hi all,
I've a character value which is like "2012-07-07T20:44:30.293Z". I would like to change this format to datetime
Required : 2012-07-07T20:44:30.293Z
Thanks.

[sbxkoenk]

Hello,

What is 'Z'?

data _NULL_;
 a="2012-07-07T20:44:30.293Z";
 b=input(scan(a,1,'T'),YYMMDD10.); put b= date9.;
 c=input(compress(scan(a,2,'T'),'Z'),time12.3); put c= time12.3;
 d=b*24*60*60 + c; put d= datetime22.3;
run;
/* end of program */

Koen

[Pandu2]

Z refers to ZULU

[Kurt_Bremser]

I think "Z" means "Zulu Time", which is short for Coordinated Universal Time, or what is commonly known as GMT.

So simply discarding it will be OK.

[Reeza]

That's an ISO date and there should be informats to handle it directly. 

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/leforinforref/n09tmeo4t9edo2n145twyoew1txu.ht...

data demo;
 a="2012-07-07T20:44:30.293Z";
 b=input(a, B8601DZ.);
 format b B8601DZ.;
run;

proc print;run;

---

@Pandu2 wrote:
Hi all,
I've a character value which is like "2012-07-07T20:44:30.293Z". I would like to change this format to datetime
Required : 2012-07-07T20:44:30.293Z
Thanks.

---

[sbxkoenk]

@Reeza : thanks for learning me something new.

@Pandu2 : sorry for my earlier reply which was of little or no use to you.

Koen

[Kurt_Bremser]

I would rather use the extended ISO 8601 formats/informats:

data demo;
 a="2012-07-07T20:44:30.293Z";
 b=input(a,e8601DZ.);
 format b e8601DZ.;
run;