Playing with Dates

netfrugal

I want to select * from my db, but I want to select from the current date and back.

$date = date('Y-m-d');

$sql = "SELECT * FROM TABLE1 WHERE column1 = '$date'";

I have a mixture of dates in column1. Some are in the past, others are in the future. But I'm only needing to query any record from the current day and in the past.

Not sure how that is accomplished in the variable.

nemonoman

Use the database's built in current date function: CURRENT_DATE()

CURRENT_DATE() returns the database's current date in the form '2007-05-13'

SELECT *
FROM table1
WHERE column1<=CURRENT_DATE()

In order for this to work, column1 will need to be a date-format column.

bradgrafelman

nemonoman wrote:
In order for this to work, column1 will need to be a date-format column.

And since it's a date, there's no reason it shouldn't be this type of column.