Convert Timestamp to date & time

dhir — Mon, 24 Jul 2017 11:46:53 GMT

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.

Re: Convert Timestamp to date & time

Kurt_Bremser — Mon, 24 Jul 2017 12:01:33 GMT

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.