Convert Timestamp to date & time

[dhir]

Hi, I have a dataset where variable 'Timestamp' has observations like 

15189430314595
15443763999343
15443763999343
15486949615495

in a sequence. This is in nanoseconds as per the description of the database. 

I want to convert these variables in date (mm/dd/yyyy) & time (hh:mm:ss) format. 

Thanks in advance. 

[Kurt_Bremser]

It is essential to know the cutoff timestamp (the moment when 0 nanoseconds were registered).

With this knowledge, you can do the calculation:

seconds = nanoseconds / 1000000000

and then correct for a zero-point that is different from the zero-point of SAS (01jan1960:00:00:00)

As your numbers are rather small, I suspect that you don't really have nanoseconds

(milli - 1/1000th

micro - 1/1000000

nano - 1/1000000000)

If your values were really nanoseconds, they would just describe a time value between 4:13:09 and 4:18:07. No datetimes here.