I was playing with different date format in SQL Server as need to display date in YYYY-MM-DD HH:MI:SS.MMM format. I knew there is a CONVERT function which can do this however I did not have the exact parameter value to convert my date to mentioned format. I got really use full chart on internet which provides different option and parameter value for CONVERT function. For my case syntax is
SELECT CONVERT(nvarchar(23),GetDate(),121)
You can check complete table here.
Happy Programming !!!!
Chirag Darji
ASP.NET Consultant & Trainer
hi….pls i m in need of rating code….could u plese send me that code…
thanx in advance….
i want sql interview question
Hi every body
i am trying for job on Dotnet with 3 years exp.
i want to know questions and answers on Asp.net based on projects questions, i mean common questions for every project