How to convert the format = dd/mm/yyyy (20/12/2015)

Question

I want to convert the format(20/12/2015) and bind into Gridview with LINQ code by each of the day that I retrieve from database. Can anyone help me in my problem? Thanks a lot :-)

Syed Shanu · Answer

Hi You can convert the date as your required format in your SQL Query here is the sample query for you. This query will return you todays date with your format. SELECT convert(varchar getdate() 103) as myDateformat The same abouve format can be used in your select query instead YOURDateColumnName give your actual table date column name. Select convert(varchar YOURDateColumnName) 103) as myDateformat from YOURTableName

How to convert the format => dd/mm/yyyy (20/12/2015)