How to convert time to 24 hr format

[Gil_]

Hi I have a datetime field open date
08/01/2017 1;42;00 PM
I need to convert the date to
08/01/2017 13:42 PM

Thanks

[Shmuel]

Change format from DATEAMPMw.  to DATETIMEw. where w is length of output dislaying date and time.

If time is 13:42 there is no need to add PM.

[Gil_]

Hi Shmuel.
Thanks for response...how do I apply it I'm using a
Data table1;
Set table1;
Time =timepart (open _date);
Format time datetime.;
Run;

It gives 01jan1960 05:49:53 the time is still at general time

[Shmuel]

When you use function TIMEPART you have time only, without the date.

format DATETIME is to be used with your variable Open_Date.

Use format time5. or time7. for TIME (as timepart).

Data table1;
Set table1;
Time =timepart (open _date);
Format open_date datetime. 
            time    time7.;
Run;

Look at next link - formats by categories:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a001263753.htm

[Gil_]

Thanks for the example it did 2 things it convert all my dates to 01jan6005:49:53. So the column of time it does give me the right format but the time is 5:49:53 should be 04:49:53 .. I'm using your data set .. thanks

[Shmuel]

You compute 

Time =timepart (open_date);

which gives you a date of 01jan60 - this turns a red light, maybe your variable Open_Date is not a datetime but a time only.

In sas 0 (zero) is equal to Jan 1st 1960.

Try do:

Data _NULL_;
set have;
 put open_date  time9.;
run;

and check the log.