| Standard Formats |
| Display Example |
Format Code (Case Sensitive) |
| 3/9/2008 |
d |
| 4:05:07 PM |
T |
| Sunday, March 09, 2008 |
D |
| Sunday, March 09, 2008 4:05 PM |
f |
| Sunday, March 09, 2008 4:05:07 PM |
F |
| Sun, 09 Mar 2008 16:05:07 GMT |
r |
| 3/9/2008 4:05 PM |
g |
| 3/9/2008 4:05:07 PM |
G |
| March 09 |
m |
| March, 2008 |
y |
| 2008-03-09T16:05:07 |
s |
| 2008-03-09 16:05:07Z |
u |
| |
| Custom Formats |
| Display Example |
Format Code (Case Sensitive) |
| 3/9/2008 |
M/d/yyyy |
| 03/09/2008 |
MM/dd/yyyy |
| Sun, Mar 9, 2008 |
ddd, MMM d, yyyy |
| Sunday, March 9, 2008 |
dddd, MMMM d, yyyy |
| 03/09/08 |
MM/dd/yy |
| 03/09/2008 |
MM/dd/yyyy |
| SQL Date Formats |
| Display Example |
Format Code |
| 03/09/2008 |
DATEADD(dd, 0, DATEDIFF(dd, 0, @your_date)) |