SQR can be used to alter the default date format of the database ensure that the proper date is queried and displayed as part of a report. This is a good solution for versions of SQR prior to release 4.0. Consistent with a new DATE datatype, SQR also introduced a set of database independent date manipulation functions which allow users to easily perform complex date manipulations. Finally, SQR version 4 provides users the ability to set a default date format for the display of dates in a report. SQR users can store full date precision in the new internal date format, but are not required to display all four digits of the year when using the DATE datatype.
Reports can conveniently display or print dates in the date mask of their choosing.