Using String-to-Date Conversions

If you convert a string variable or constant to a date variable without specifying an edit mask that identifies the format of the string, SQR applies a date format. This implicit conversion takes place with these commands:

  • MOVE.

  • The strtodate function.

  • The DISPLAY, PRINT, or SHOW commands when used to format a string variable as a date.

SQR attempts to apply date formats in this order:

  1. The format specified in SQR_DB_DATE_FORMAT.

  2. The database-dependent format.

  3. The SYYYYMMDD[HH24[MI[SS[NNNNNN]]]] literal date format.