Get date and time value from Epoch

[hhchenfx]

Hi Everyone,

I would like to get date and time from Epoch value such as:

1688750835759

will give date: 07JUL2023  and GMT time: 17:27:15.759

Can you please help?

Thank you so much.

HHC

data test;format epoch comma32.;
input epoch;
datalines;
1688750835759
;
run;

data test;set test;
*format dt datetime24.3;
drop dt seconds;
format date date9.;
format clock_time time9.;

seconds=epoch/1000;
dt = seconds + '01JAN1970:00:00'dt ;
date=datepart(dt);
clock_time=timepart(dt);
run;

[PaigeMiller]

https://communities.sas.com/t5/SAS-Enterprise-Guide/EPOCH-Time-conversion/m-p/104155#M9092

[Tom · Accepted solution]

Just convert the milliseconds to seconds and add the number seconds between 1960 and 1970.

251  data test;
252   epoch=1688750835759 ;
253   seconds=epoch/1000;
254   dt = seconds + '01JAN1970:00:00'dt ;
255   put epoch= comma32. / seconds=comma32.3 / dt=datetime24.3 ;
256  run;

epoch=1,688,750,835,759
seconds=1,688,750,835.759
dt=07JUL2023:17:27:15.759

[hhchenfx]

Thank you so much, Tom.

HHC