How can i convert date like 24/12/2017 12:34:12 pm to date like 24/12/2017 in sql and c#

Question

help me

Answer 1

https://stackoverflow.com/questions/113045/how-to-return-the-date-part-only-from-a-sql-server-datetime-datatype

Answer 2

thanks

Answer 3

In plain language, you could create a function to copy the value of the firstDate to a string firstDate variable and then reference the appropriate characters from that variable in new variables (day, month, year) and pass them as arguments in a string-to-integer method and combine them all in a secondDate variable.

Answer 4

the date in database "datetime" and I want to convert it to date only to select between range in my app

Answer 5

using c# in my app