0

I want to show date in grid view but now there is time shows as well with date. I just enter simple query to access date column from table e.g i tried

string query="select date from attendance where month='October';

It returns date+time

Alimon Karim
  • 4,354
  • 10
  • 43
  • 68
usman siddique
  • 33
  • 3
  • Duplicate? http://stackoverflow.com/questions/17205441/convert-date-format-into-dd-mmm-yyyy-format-in-sql-server-2008 – Neville Kuyt Oct 09 '15 at 10:16
  • Possible duplicate of [How to return the date part only from a SQL Server datetime datatype](http://stackoverflow.com/questions/113045/how-to-return-the-date-part-only-from-a-sql-server-datetime-datatype) – Alimon Karim Oct 09 '15 at 10:23

0 Answers0