## Get date and time value from Epoch

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

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;
``````
1 ACCEPTED SOLUTION

Accepted Solutions

## Re: Get date and time value from Epoch

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
```
3 REPLIES 3

## Re: Get date and time value from Epoch

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
```

## Re: Get date and time value from Epoch

Thank you so much, Tom.

HHC

Discussion stats
• 3 replies
• 225 views
• 1 like
• 3 in conversation