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.