Conversion failed when converting the varchar value '2018-01

Question

actually database in datatype is Date. but not filter the data display

Manav Pandya · Answer

The code i have provided  is convert date to int An from following code you can convert it to varchar also : declare @date date = '2018-01-18' select convert(varchar @date 112) Thanks

Manav Pandya · Answer

Hello First of all this is not the correct way to use Date I have executed Following : declare @date date = '2018-01-18' select convert( int  convert(varchar(10) @date 112)) And Output : 20180118 I hope you can understand Thanks

Ajeesh · Answer

Rupesh You have to add the code provided by Manav on the sql query which you are using to populate the datatable

Rupesh N · Answer

where to declare. i mean convert date in to varchar ? or visual studio to declare?