MySQL Forums
Forum List  »  PHP

Re: PHP PDO Select using date clause not working
Posted by: Mauro Simoes
Date: November 05, 2020 12:11PM

I did not make myself clear. I'm sorry.

To solve the problem, I created one more field in that table.

The column data_trabalhada(DATE) I changed to data_trabalhada (VARCHAR).

After, I created a new column milis(BIG).

When inserting dates, the first receives date in string format (for display purposes) and the other number, which is that same date in milliseconds is used in WHERE clause searching records between two 'dates'.

Options: ReplyQuote

Written By
Re: PHP PDO Select using date clause not working
November 05, 2020 12:11PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.