Loading

How to get date only with put Time

jagannadham palika

Hi ,

i want in sql server table between date is not work if it is front end of the windows application date not suport to generate report plz give a valueble solution for that convert(varchar(24),p.Transactiondate,113) between '2016-07-01' and '2016-07-15'

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Krishna Rajput Singh10y ago
Accepted answer
Hi Thanks for writing below links helpful for you.......
http://stackoverflow.com/questions/13178752/current-date-without-time
http://blog.sqlauthority.com/2007/06/10/sql-server-retrieve-select-only-date-part-from-datetime-best-practice/