Use a statement like the following to display a date in uppercase:
SELECT DATE (FORMAT 'MMMbdd,bYYYY') (CHAR(12), UC);
Using 1985-09-12 for data, this statement returns:
SEP 12, 1985
The following query shows how to specify a date if, for example, the p_date column was specified as FORMAT ' DDBMMMBYYYY ':
SELECT * FROM sales WHERE p_date = '30 Mar 1994';
If the p_date column was specified as FORMAT ' YYYY-MM-DD ', the query would be as follows:
SELECT * FROM sales WHERE p_date = '1994-03-30';