Friday, 3 May 2013

Convert fucntion use in sql


select(CONVERT(VARCHAR(19),GETDATE()))
select(CONVERT(VARCHAR(10),GETDATE(),10))
select(CONVERT(VARCHAR(10),GETDATE(),110))
select(CONVERT(VARCHAR(11),GETDATE(),6))
select(CONVERT(VARCHAR(11),GETDATE(),106))
select(CONVERT(VARCHAR(24),GETDATE(),113))

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home