This DATE type is no longer represented as a string, but instead stores all date information in an internal data structure that accounts for both date and time attributes. Consistent with the DATE type, SQR also introduced a set of database-independent functions that allow developers to easily perform complex date manipulations. With these enhancements, SQR developers can create programs that inherently prevent loss of date precision. Also, version 4 gives developers control over the display of dates. SQR developers 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 data type.
Reports can conveniently display or print dates in the date mask of their choosing.
You can explicitly declare a date variable as part of an SQR program. This date variable can be used, managed, and transformed during program execution. Once a date variable has been introduced, SQR version 4 supports functions for manipulating dates. Converts a date variable to a string. Converts a date stored as a string to a date type.