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 date to dd.mm.yyyy format
To Convert the date to dd/mm/yyyy format, use the following query
Query
SELECT CONVERT(VARCHAR(20), GETDATE(),104)
Return Value
01.08.2013
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment