Different Types of SQL Date Formats
1
|
101
|
USA
|
mm/dd/yy
|
2
|
102
|
ANSI
|
yy.mm.dd
|
3
|
103
|
British/French
|
dd/mm/yy
|
4
|
104
|
German
|
dd.mm.yy
|
5
|
105
|
Italian
|
dd-mm-yy
|
6
|
106
|
-
|
dd
mon yy
|
7
|
107
|
-
|
Mon
dd, yy
|
8
|
113
|
select replace(convert(varchar(11), -
getdate (), 113),' ','-')
|
14-Dec-2012
|
9
|
103
|
select replace(CONVERT(varchar,DOB, 103),'/','')as DOB from Table
|
ddmmyyyy
|
10
|
100
|
SELECT
CONVERT(CHAR(4), getdate(), 100) as Month
|
Mar
|
11
|
120
|
SELECT
CONVERT(CHAR(4), getdate(), 120) as Month
|
2013
|
12
|
select datename(dw,getdate())
|
Tuesday
|
|
13
|
select datepart(dw,getdate())
|
2
|
|
No comments:
Post a Comment