All pastes #770552 Raw Edit

Miscellany

public text v1 · immutable
·published 2007-11-12 11:52 UTC
rendered paste body
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.