I have timestamps from Oracle stored in a CSV file as data type long. This timestamp is generated using the Java function getTime(), see https://docs.oracle.com/javase/8/docs/api/java/sql/Timestamp.html
Timestamp looks like this, for example: 1723207241234. In the Oracle documentation I found that it is milliseconds since January 1, 1970, 00:00:00 GMT.
So, I need to parse timestamp generated using Java function in Oracle (get date and time from timestamp) and store these values in SAS tables. Is there any way to do this?
9
SAS stores its datetimes since seconds from Jan 1st, 1960 00:00:00 GMT. To convert this to a SAS datetime, you must add 10 years to the Unix datetime value in seconds. '01JAN1970:00:00'dt in SAS converts to 10 years in seconds.
data want;
time = 1723207241234/1000 + '01JAN1970:00:00'dt;
format time datetime20.;
run;
time
09AUG2024:12:40:41