1. SELECT CONVERT(CHAR(20), GETDATE(), 103) AS DATE

2. SELECT DATEADD(DD, 36, GETDATE()) AS DATE
   SELECT DATEADD(DD, 45, GETDATE()) AS DATE

3. SELECT DATEADD(mm, 3, GETDATE()) AS DATE
   SELECT DATEADD(mm, -4, GETDATE()) AS DATE

4. SELECT DATEADD(YY, 5, GETDATE()) AS DATE
   SELECT DATEADD(YY, -15, GETDATE()) AS DATE

5. SELECT ENAME, CONVERT(CHAR(20), HIREDATE, 107) AS DATE_HIRED FROM EMP

6. 1900-01-01 00:00:00.000
   1900-01-01 00:01:26.400

7. SELECT 'SHMERA EINAI ' + DATENAME(MM, GETDATE()) + ' KAI O MHNAS EXEI ' + DATENAME(DD, GETDATE()) AS DATE

8.