Simplified DateTime

[sdang]

How can I make this DateTime variable (See below) to "01Jan2015:00:00:00.000"dt  and still have it as Date/Time variable.

thanks

[sdang]

Just wanted to add.  I still want to keep it as Date/Time variable but with the seconds., etc as  00:00:00.000.

[SASKiwi]

proc format;

   picture MyDT
  other = '%d%B%Y:%0H:%0M:%0s' (DATATYPE=DATETIME);

run;

data _null_;

  now = datetime();

  format now MyDT26.3;

  put now = ;

run;

[sdang]

It is not doing it.  I still have the same result, showing the trailing minutes and seconds.. I want minutes and seconds as 00:00:00.000.  The result I wanted like that because I have two data sets with PlayDate and IGTCreatedDate (see image below).  I want to join them together.

Above is just a sample data.  I want to show the format between PlayerDayDate and IGTAccountCreated.  Because of the format I cannot join them together. The reason I want to join them is to see if a guest join on 01May2015 and play on 01May2015.

Please help me.

[ballardw · Accepted solution]

or

datetimevariable = dhms(datepart(datetimevariable),0,0,0);

[sdang]

Thank you, that is what I need.  You solved my problem.

[sdang]

Thank you

SASKiwi