I am trying to fetch data from sql server data base from C# code.
I have 2 columns of "datetime" data type.
but i want only date part of that field when feting data from C#.
When i am using same query in SSMS , it is showing only date part as per my requirement.
but when i am convert in C# and feting data from C# then it is showing full date time data.
What I have tried:
SQL query which is working is SSMS
SELECT tk.TaskLisiId, tk.JobNumber, tk.PM, tk.TM,
tk.Description, CONVERT(Date, tk.Date) as Date,
CONVERT(Date, tk.CompletedByDate) as CompletedByDate, tk.Status
FROM TaskList tk WHERE tk.TaskLisiId<>0
query using when feting data from database in C#
string queryString = "SELECT tk.TaskLisiId, tk.JobNumber, tk.PM, tk.TM, tk.Description, CONVERT(Date, tk.Date) as Date," +
"CONVERT(Date, tk.CompletedByDate) as CompletedByDate, tk.Status FROM TaskList tk WHERE tk.TaskLisiId<>0";