 /*

FORMAT Phrase	                        Result
-------------------------------------------------------------------------
FORMAT 'YY/MM/DD'	                    85/09/12
FORMAT 'DD-MM-YY'	                    12-09-85
FORMAT 'YYYY/MM/DD'	                    1985/09/12
FORMAT 'YYYY-MM-DD'	                    1985-09-12
FORMAT 'YYYY.DDD'	                    1985.225
FORMAT 'YYBDDD'	                        85 225
FORMAT 'DDBMMMBYYYY'	                12 Sep 1985
FORMAT 'MMMBDD,BYYYY'	                Sep 12, 1985
FORMAT 'YYYYBMMMBDD'	                1985 Sep 12
FORMAT 'MMM'	                        Sep
FORMAT 'EEE,BM4BDD,BYYYY'	            Thu, September 12, 1985
FORMAT 'E4,BMMMMBDD,BYYYY'	            Thursday, September 12, 1985
FORMAT 'HH:MIBT'	                    01:20 PM
FORMAT 'HH:MI'	                        13:20
FORMAT 'HH.MI.SS'	                    13.20.53
FORMAT 'MM/DD/YYBHH:MIBT'	            09/12/85 01:20 PM
FORMAT 'MMMBDD,BYYBHH:MI:SS'	        Sep 12, 85 13:20:53
FORMAT 'E3,BM4BDD,BY4BHH:MI:SSDS(F)'	Thu, September 12, 1985 13:20:53.64
FORMAT 'YYYY-MM-DDBHH:MI:SSDS(F)Z'	    1985-09-12 13:20:53.64+03:00

*/

 

SELECT CURRENT_DATE 

SELECT CURRENT_DATE (FORMAT 'MM/DD/YYYY') (CHAR(10))



SELECT CURRENT_DATE (FORMAT 'MM/DD/YYYY') (CHAR(25))


SELECT CURRENT_DATE (FORMAT 'MM/DD/YYYY') (CHAR(5))




SELECT CURRENT_DATE (FORMAT 'MMMBDD,BYYYY') (CHAR(12))





SELECT CURRENT_DATE (FORMAT 'MMMBDD,BYYYY') (CHAR(12), UC)



SELECT CURRENT_DATE (FORMAT 'M4BDD,BYYYY') (CHAR(12), UC)
	




SELECT CURRENT_DATE (FORMAT 'EEE,BM4BDD,BYYYY'	) (CHAR(25), UC) AS ABBREVIATED_DAY,
       CURRENT_DATE (FORMAT 'E4,BM4BDD,BYYYY'	) (CHAR(25), UC) AS FULL_DAY




SELECT CURRENT_TIMESTAMP (FORMAT 'M4bdd,bYYYY') (CHAR(12), UC) AS MONTH_DAY_YEAR,
       CURRENT_TIMESTAMP (FORMAT 'M4BDD,BYYBHH:MI:SS') (CHAR(50), UC) AS WITH_TIMESTAMP











