- Add days/months/years to a given datetime
Add days to a given days:
SELECT DATEADD(DAY, -1, ‘2015-11-30’)
SELECT DATEADD(DAY, 1, GETDATE())
Same logic for add years or month
MONTH: SELECT DATEADD(MONTH, 1, GETDATE())
YEAR: SELECT DATEADD(YEAR, 1, GETDATE())
2.Displaying date in different formats.
- default: SELECT CONVERT(char(20),GETDATE(),0)
- USA mm/dd/yyyy: SELECT CONVERT(char(20),GETDATE(),101) SELECT CONVERT(char(20),GETDATE(),1)
mm-dd-yyyy : SELECT CONVERT(char(20),GETDATE(),110)
- British/France dd/mm/yyyy: SELECT CONVERT(char(20),GETDATE(),103)
- German dd.mm.yyyy: SELECT CONVERT(char(20),GETDATE(),104)
- Italian dd-mm-yyyy: SELECT CONVERT(char(20),GETDATE(),105)
- Japan yyyy/mm/dd: SELECT CONVERT(char(20),GETDATE(),111)
- ISO yyyymmdd: SELECT CONVERT(char(20),GETDATE(),112)
- Some other formats: SELECT CONVERT(char(20),GETDATE(),106) SELECT CONVERT(char(20),GETDATE(),107) SELECT CONVERT(char(20),GETDATE(),108) only display time SELECT CONVERT(char(20),GETDATE(),109)