Convert Timestamp to date & time

Reply
Occasional Contributor
Posts: 17

Convert Timestamp to date & time

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. 

 

 

Super User
Posts: 7,758

Re: Convert Timestamp to date & time

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 1 reply
  • 158 views
  • 0 likes
  • 2 in conversation