SAS® Visual Analytics includes seconds for the Date,Time (DATETIME10.) format in languages other than English (United States)


The format Date,Time (DATETIME10.) includes seconds when SAS Visual Analytics is running in languages other than English (United States). The following display shows the format when the language is set to Spanish.

Formato is 25/06/2014 08:10:55

The following display shows the same format when the language is set to English (United States).

Format is Jun 25, 2014 08:10 AM

This difference in behavior occurs because a 12-hour clock is used for English (United States), which requires the format to include AM and PM, leaving no room to include seconds. In languages that use a 24-hour clock, there is room to include the seconds because AM and PM are not required.

For languages that use a 24-hour clock, there is no Date,Time format that does not include seconds. In order to use a format that does not include seconds, the only workaround is to change the language to English (United States).