You are viewing the documentation for Blueriq 18. Documentation for other versions is available in our documentation directory.

Date patternRangeDescriptionFormat only
d1-31Displays the day as a number without a leading zero.(warning) 
dd1-31Displays the day as a number with a leading zero when appropriate.
M1-12Displays the month as a number without a leading zero.(warning) 
MM1-12Displays the month as a number with a leading zero when appropriate.
yy0-99Displays the year as a two-digit number (using the last two digits).(warning) 
yyyy1-9999Displays the year as a four-digit number.
h0-11Displays the hour as a number without a leading zero, based on the 12-hour clock.(warning) 
HH0-23Displays the hour as a number with a leading zero, based on the 24-hour clock.
hh0-11Displays the hour as a number with a leading zero, based on the 12-hour clock.(warning) 
mm0-59Displays the minute as a number with a leading zero.
ss0-59Displays the second as a number with a leading zero.
S0-9Displays the decisecond
SS0-99Displays the centisecond
SSS0-999Displays the millisecond
aN/ADisplays AM for times from midnight until noon and PM for times from noon until midnight.(warning)


The 'null' date is 1970-01-01, that means when the year, month or day are not in the date/time pattern, the respective values will be used.


The following characters are allowed to be used as separators in a date pattern:


CharacterDescription
-Hyphen
,Comma
.Period
;Semicolon
:Colon

Space
/Forward slash
TTime separator


Although it is possible to add extra separator characters through custom (Java) code, these characters will have no special meaning. For example when adding the 'Z' character to the end of the date/time pattern, this will NOT be treated as a time zone designator. All date/times are interpreted using the system default timezone.


  • No labels

Didn't find the answer you were looking for? Try the advanced search!