Saturday, January 08, 2005

Query to find the day ina date

The following query can be used to get the day of any date

SELECT TO_CHAR(TO_DATE('01-JAN-05','DD-MON-RR'),'Dy') as day FROM dual;


No comments: