topic Re: Current date time in datetime format in New SAS User

Current date time in datetime format

scb — Wed, 17 Oct 2018 06:53:15 GMT

May I know how to get the "Today Datetime" in current datetime instead of 1960? Thanks.

data _null_;

x=today();

y=x;
z=x;

format y date9.;
format z datetime20.;

put "Unformatted:" x "Formatted:" y "Today Datetime:" z;
run;

Kurt_Bremser — Wed, 17 Oct 2018 07:02:20 GMT

today() delivers a date, which is the count of days from 1960-01-01.

A datetime format expects a count of seconds from 1960-01-01T00:00:00.

That's why you get a timestamp from 1960-01-01.

Either use the datetime() function, or a date format.

Criptic — Wed, 17 Oct 2018 07:43:04 GMT

data _null_;
 x = today();
 format x ddmmyy10.;
 y = datetime();
 format y datetime20.;
 put "Formatted day: " x " , formatted datetime: " y;
run;

Rohit2RaiAxis — Mon, 26 Oct 2020 10:10:51 GMT

You can multiply the date you get from today() by 86400 to get DD:MM:YYYY:00:00:00