Tuesday, February 8, 2011

Different types of date show

different types of show date

SELECT CONVERT(VARCHAR(100),GETDATE(),100) --Feb 8 2011 5:43PM
SELECT CONVERT(VARCHAR(100),GETDATE(),101) --02/08/2011
SELECT CONVERT(VARCHAR(100),GETDATE(),102) --2011.02.08
SELECT CONVERT(VARCHAR(100),GETDATE(),103) --08/02/2011
SELECT CONVERT(VARCHAR(100),GETDATE(),104)--08.02.2011
SELECT CONVERT(VARCHAR(100),GETDATE(),105)-- 08-02-2011
SELECT CONVERT(VARCHAR(100),GETDATE(),106) --08 Feb 2011
SELECT CONVERT(VARCHAR(100),GETDATE(),107) --Feb 08, 2011
SELECT CONVERT(VARCHAR(100),GETDATE(),108) --17:41:36
SELECT CONVERT(VARCHAR(100),GETDATE(),109) --Feb 8 2011 5:41:57:530PM
SELECT CONVERT(VARCHAR(100),GETDATE(),112) --20110208
SELECT CONVERT(VARCHAR(100), GETDATE(),113) --08 Feb 2011 17:43:44:903
SELECT CONVERT(VARCHAR(100), GETDATE(),114) --17:44:04:450
SELECT CONVERT(VARCHAR(100), GETDATE(),110) --ANSWER :02-08-2011

SELECT CONVERT(VARCHAR(100),GETDATE(),120) --201102082011-02-08 17:45:17

SELECT CONVERT(VARCHAR(100),GETDATE(),111) --2011/02/08

SELECT CONVERT(VARCHAR(100),GETDATE(),121)--2011-02-08 17:45:43.513

No comments:

Post a Comment