J
J
jtag2017-09-27 11:56:43
MySQL
jtag, 2017-09-27 11:56:43

How to check if the date is equal to the current one?

The date is written in varchar (2017-09-06 07:35:53). How to check only the date, that it is current?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
0
0xD34F, 2017-09-27
@0xD34F

SELECT CURRENT_DATE = DATE('2017-09-06 07:35:53')

R
RidgeA, 2017-09-27
@RidgeA

https://dev.mysql.com/doc/refman/5.7/en/date-and-t...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question