Date constant—Data extract expressions

The following rules apply for date constants:

  • Date constants are coded as D'constantValue', where constantValue is a decimal string of digits representing a Gregorian or Julian date. In general, it does not matter which type of date you specify because all dates are normalized to a format that makes them identical internally.
  • The components of the date will be validated and will result in errors if the date is not valid.
  • The length of the constantValue determines the format of the date.
  • Two-digit years are not allowed in date constants.
  • Gregorian date constants are eight-digit values in the format yyyymmdd.
  • Julian date constants are seven-digit values in the format yyyyddd.

Related topic

Data-extract-expressions-with-the-WHEN-and-FIELD-keywords

For information on the handling of dates, see Date-support.

Example

Gregorian date constants

D'20031225'
D'19450208'
D'19830401'
Example

Julian date constants

D'2004350'
D'1945039'
D'1982210'

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*