|
 |
| Note:
This uses the internal blog search engine. The Google search engine is also available at the top of the page. |
|
|
 |
|
|
|
|
|
Please review the site disclaimer before downloading or using content found on this site
|
|
|
|
|
|
|
|
|
|
As always, I welcome your comments!
May
5
Written by:
Steve Gray
5/5/2011 10:10 AM
The msdn article on Cast an Convert is perfectly clear when it comes to how Cast and Convert manipulate the date values into text. http://msdn.microsoft.com/en-us/library/ms187928.aspx But… it’s just a little bit easier to see it printed out. Here’s a short script that prints out all the different CASTS that are possible and give an example. ‘127’ is in the SQL 2008 R2 documentation but failed against the SQL 200 server I was testing on, so I commented it out. - print convert(varchar(40),getdate(),0) -- May 5 2011 11:00AM
- print convert(varchar(40),getdate(),100) -- May 5 2011 11:00AM
- print convert(varchar(40),getdate(),1) -- 05/05/11
- print convert(varchar(40),getdate(),101) -- 05/05/2011
- print convert(varchar(40),getdate(),2) -- 11.05.05
- print convert(varchar(40),getdate(),102) -- 2011.05.05
- print convert(varchar(40),getdate(),3) -- 05/05/11
- print convert(varchar(40),getdate(),103) -- 05/05/2011
- print convert(varchar(40),getdate(),4) -- 05.05.11
- print convert(varchar(40),getdate(),104) -- 05.05.2011
- print convert(varchar(40),getdate(),5) -- 05-05-11
- print convert(varchar(40),getdate(),105) -- 05-05-2011
- print convert(varchar(40),getdate(),6) -- 05 May 11
- print convert(varchar(40),getdate(),106) -- 05 May 2011
- print convert(varchar(40),getdate(),7) -- May 05, 11
- print convert(varchar(40),getdate(),107) -- May 05, 2011
- print convert(varchar(40),getdate(),8) -- 11:00:57
- print convert(varchar(40),getdate(),108) -- 11:00:57
- print convert(varchar(40),getdate(),9) -- May 5 2011 11:00:57:513AM
- print convert(varchar(40),getdate(),109) -- May 5 2011 11:00:57:513AM
- print convert(varchar(40),getdate(),10) -- 05-05-11
- print convert(varchar(40),getdate(),110) -- 05-05-2011
- print convert(varchar(40),getdate(),11) -- 11/05/05
- print convert(varchar(40),getdate(),111) -- 2011/05/05
- print convert(varchar(40),getdate(),12) -- 110505
- print convert(varchar(40),getdate(),112) -- 20110505
- print convert(varchar(40),getdate(),13) -- 05 May 2011 11:00:57:513
- print convert(varchar(40),getdate(),113) -- 05 May 2011 11:00:57:513
- print convert(varchar(40),getdate(),14) -- 11:00:57:513
- print convert(varchar(40),getdate(),114) -- 11:00:57:513
- print convert(varchar(40),getdate(),20) -- 2011-05-05 11:00:57
- print convert(varchar(40),getdate(),120) -- 2011-05-05 11:00:57
- print convert(varchar(40),getdate(),121) -- 2011-05-05 11:00:57.513
- print convert(varchar(40),getdate(),126) -- 2011-05-05T11:00:57.513
- --print convert(varchar(40),getdate(),127) --
- print convert(varchar(40),getdate(),130) -- 2 ????? ??????? 1432 11:00:57:513AM
- print convert(varchar(40),getdate(),131) -- 2/06/1432 11:00:57:513AM
As always, I welcome your comments! |
|
|
|
|
|
|
|
|
|