Note : don’t login using ‘sa’, please login using windows authentification for creating schedule/maintenance plan Creating a SQL Server 2005 Maintenance Plan If you are going to use new Maintenance Plan features, I strongly recommend installing SQL Server 2005 Service Pack 1 first. Among the new features and improvements that are included in SQL Server … Continue reading
A. Getting Year, Month, Day from Date SQL> — EXTRACT(): return a year, month, day, hour, minute, second, or time zone from x; SQL> SQL> SELECT EXTRACT(YEAR FROM TO_DATE(’01-JAN-2005 19:15:26′,’DD-MON-YYYY HH24:MI:SS’)) AS YEAR FROM dual; YEAR ———- 2005 B. Date Format & Number Format TO_CHAR Convert a numeric or date expression to a character String. … Continue reading