converting datetime to date9.

[sasthebest]

I used format = date9. to convert datetime to date9. but it doesn't work in an SQL statement. Any help?

[Scott_Mitchell]

DATA HAVE;

  ATTRIB DATETIME1 FORMAT=DATETIME12.;

  DATETIME1 = DHMS(TODAY(),12,15,0);

RUN;

PROC SQL;

  CREATE TABLE WANT AS

  SELECT DATEPART(DATETIME1) AS DATE1 FORMAT = DATE9.

  FROM HAVE;

RUN;

[Peter_C · Accepted solution]

Alrernatively

DTDATE9.

presents dateime values in date9. style