Comments by Member 12156793 (Top 5 by date)

plz explain.. in sql table patientadmissiondate field in datetime format..

c#(MVC) var rep = from s in ctx.tbreports
where s.dateofreport == date
select s;

thanks for the update. However, i still am not able to do the comparison as using the above update i now get the date in this format i.e 11/24/2015.. i need it in this format 11/24/2015 10:46:05 AM. what change is required for that and Do i change the query where i insert date in database?

Please guide how can i keep data in 11/24/2015 10:46:05 AM format in sql field