Answer the question
In order to leave comments, you need to log in
How to execute a SQL query on the current date if the date type is datetime?
I have a DATE column with type DATETIME , we need to select all records with today's date.
select date from table where date=getdate() does not work... if you put operators less than or equal to or between then it works....
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question