| |
Title: Convert Date time function In SQl Introduction
This article explain How convert Different Date time format using convert function in sql Technologies
SQl server Prerequisite SQl server Implementation CONVERT (datatype, date-time (input), date display style) Parameters:
datatype: Any data type from nchar, nvarchar, char, varchar, [length is optional], e.g. varchar(14) or nvarchar(14)
date-time-(input) Date time string supplied as input (You can use GETDATE() function etc.)
Date display style: The string style (You need '2009.08.12' or '12/08/2009' etc. You can even use the useful style number. Like) Select Statement | Output | SELECT CONVERT(VARCHAR(20),GETDATE(),100) | Aug 12 2009 12:18PM | SELECT CONVERT(VARCHAR(20),GETDATE(),101) | 08/12/2009 | SELECT CONVERT(VARCHAR(20),GETDATE(),102) | 2009.08.12 | SELECT CONVERT(VARCHAR(20),GETDATE(),103) | 12/08/2009 | SELECT CONVERT(VARCHAR(20),GETDATE(),104) | 12.08.2009 | SELECT CONVERT(VARCHAR(20),GETDATE(),105) | 12-08-2009 | SELECT CONVERT(VARCHAR(20),GETDATE(),106) | 12 Aug 2009 | SELECT CONVERT(VARCHAR(20),GETDATE(),107) | Aug 12, 2009 | SELECT CONVERT(VARCHAR(20),GETDATE(),108) | 12:25:47 | SELECT CONVERT(VARCHAR(20),GETDATE(),109) | Aug 12 2009 12:26:07 | SELECT CONVERT(VARCHAR(20),GETDATE(),110) | 08-12-2009 | SELECT CONVERT(VARCHAR(20),GETDATE(),111) | 2009/08/12 | SELECT CONVERT(VARCHAR(20),GETDATE(),112) | 20090812 | SELECT CONVERT(VARCHAR(20),GETDATE(),113) | 12 Aug 2009 12:27:31 | SELECT CONVERT(VARCHAR(20),GETDATE(),114) | 12:27:50:587 |
Here I tried to Explain of using convert function. Get different date time style Enjoy!!!!!! Regards, Kirti M Darji | |