Convert SAS date time value to Java YYYY-MM-DD HH:mm:ss -
i have date time values coming sas ( 10 digits) 1627741415
. want convert them in java code generate java date time yyyy-mm-dd hh:mm:ss.0
i cant find how sas date time works this.
1627741415
corresponds july 31, 2011 2:33:35 p.m.
, want be
2011-07-31 14:33:35.0.
any appreciated. in advance
since sas datetime value represents number of seconds between january 1, 1960, , specified date. think use difference epoch time 1970.
i did quick test using code :
localdatetime datetime = localdatetime.parse("2011-07-31t14:33:35.0"); system.out.println(datetime.tostring()); system.out.println(datetime.toepochsecond(zoneoffset.utc)); system.out.println(" difference : "+ (1627741415 - datetime.toepochsecond(zoneoffset.utc) ));
and use difference of 315618600 calculate dates.
so have 1627741415 subtract 315618600 endup epoch date can use in application.
Comments
Post a Comment