Blog for Latest Government and Private Jobs, asp.net, vb.net, sql server, java script queries
asp.net, vb.net, sql server, ssrs, expor to excel, export to pdf and javascript related queries
Pages
Home
Travel and Tours
Health Tips
Thursday, August 1, 2013
how to convert a date to dd monthname yyyy format
To convert a date to dd monthname yyyy format in sql
Query
SELECT CONVERT(VARCHAR(20), GETDATE(),106)
Result
01 Aug 2013
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment