How do I Update a date field with today's in datetime format

[mmohotsi]

Greetings

I have a table that has a datetime field and would like to update the field with today's date using the datetime format.

I have seen a way of updating a number field  by doing this in the attached dataset:

Proc sql;

update test2

set hour = 50;

quit;

The code updates all values of the field "Hour"

I would like to update the field Date with today's date.

Furthermore, it might be required to update only a specific record say where name = 'John'. will there also be a way of updating specific record?

Thanks in advance

[PeterClemmensen]

Proc sql;
   update test2
   set hour = datetime
   where name = 'John';
quit;

[PaigeMiller · Accepted solution]

Proc sql;
    update test2 set date = datetime();
    alter table test2 modify date integer format=datetime16.;
quit;

Now test2 is a datetime value. NOTE: in some places you ask for a datetime value, and in other places you ask for a date value, which is it?

[mmohotsi]

Greetings

The solution worked perfectly. The customer request that I format today's date as a datetime field to a format 2022-02-21 13:56:45. This format starts with a year as it will suits his database field

The datetime in the accepted solution provides a datetime format that starts with the day and not the year.

Is there a way to update the field with this format?