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


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


Sorry, only registered users may post in this forum.

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.