List of All formats in SQLServer
Always it will be very hectic problem when we use Date in SQL queries with The database used in COBOL because the Date format is different.So I've done little homework on all formats of dates.
And I'll try to explain all date manipulation function.
List of all Date formats in SQLserver2005
Select convert(varchar(10),getdate() ,100) 01/18/01
Select convert(varchar(10),getdate() ,101) 01/18/10
Select convert(varchar(10),getdate() ,102) 01/18/10
Select convert(varchar(10),getdate() ,103) 18/01/2010
Select convert(varchar(10),getdate() ,104) 18.01.2010
Select convert(varchar(10),getdate() ,105) 18-01-2010
Select convert(varchar(10),getdate() ,106) 01/18/01
Select convert(varchar(10),getdate() ,107) 01/18/20
Select convert(varchar(10),getdate() ,108) 04:21:56 PM
Select convert(varchar(10),getdate() ,109) 01/18/01
Select convert(varchar(10),getdate() ,110) 01/18/10
Select convert(varchar(10),getdate() ,111) 01/18/10
Select convert(varchar(10),getdate() ,112) 20100118
Select convert(varchar(10),getdate() ,113) 01/18/01
Select convert(varchar(10),getdate() ,114) 16:21:56:5
Hope this will help You.
Hope this will help You.
0 Response to "List of All formats in SQLServer"
Post a Comment