select convert(varchar,getdate(),101)
OutPut:- 06/18/2008
select convert(varchar,getdate(),102)
OutPut:- 2008.06.18
select convert(varchar,getdate(),103)
OutPut:- 18/06/2008
select convert(varchar,getdate(),104)
OutPut:- 18.06.2008
select convert(varchar,getdate(),105)
OutPut:- 18-06-2008
select convert(varchar,getdate(),106)
OutPut:- 18 Jun 2008
select convert(varchar,getdate(),107)
OutPut:- Jun 18, 2008
select convert(varchar,getdate(),108)
OutPut:- 10:53:20
select convert(varchar,getdate(),109)
OutPut:- Jun 18 2008 10:53:30:507AM
select convert(varchar,getdate(),110)
OutPut:- 06-18-2008
select convert(varchar,getdate(),111)
OutPut:- 2008/06/18
select convert(varchar,getdate(),112)
OutPut:- 20080618
select convert(varchar,getdate(),113)
OutPut:- 18 Jun 2008 10:54:01:253
select convert(varchar,getdate(),114)
OutPut:- 10:54:08:473
select convert(varchar,getdate(),120))
OutPut:- 2008-06-18 10:54:15
|
| Author: thebarrett27 20 Jun 2008 | Member Level: Bronze Points : 0 |
thanks for a nice code
|
| Author: Bunty 22 Jun 2008 | Member Level: Diamond Points : 1 |
Hi,
Very Nice piece of code on how to use convert function and datetime in SQL Server.
It is really nice.
Keep Posting.
Thanks.
|