SQL Date Format

The SQL Date Format property specifies the format of the date string literal in the SQL statements. This setting is used when a report contains date-related qualifications.

Enter the date format using the following characters:

• mm or mmm for month
• dd for date
• yy or yyyy for year
• separators such as / and -

For example, the default format is yyyy-mm-dd. Oracle uses dd-mmm-yy and Teradata uses yyyy/mm/dd.