• Print |
• E-mail  |
• Bookmark

If a datetime value is formatted using the DATETIMEw.d format, the value may be inappropriately rounded. There are two situations when this can occur:

1. a non-zero value is used for the decimal specification of the DATETIMEw.d format

   For example:

   data _null_; x='02aug2005:00:14:23.999'dt; put x=datetime30.2; run;

   incorrectly produces:

   x=03AUG2005:00:00:00.00

   while:

   data _null_; x='02aug2005:00:14:23.999'dt; put x=datetime30.3; run;

   correctly produces:

   x=02AUG2005:00:14:23.999
2. the datetime value is less than one second from midnight

   For example:

   data _null_; dt=-1E-12; put dt=datetime.; run;

   produces:

   dt=02JAN60:00:00:00

   The format should correctly generate 01JAN60:00:00:00.

This problem is corrected in SAS^® 9.2.

Select the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at: