CODEWITHSUNDEEP
mysqldatetimewhere-clause
André Figueira
André Figueira

Reputation: 6736

MYSQL Select rows where date is older than datetime

I am coding a status item for a website and need to load statuses older than a variable that contains a datetime.

So the database has a field called added date which is a datetime field and I have a string in datetime format and i want to select all rows older than my datetime format string.

How would this be structured in MYSQL?

Thanks in advance.

Upvotes: 20

Views: 58135

Answers (3)

Moyed Ansari
Moyed Ansari

Reputation: 8461

mysql DATETIME type is used for values that contain both date and time parts.

Try this 

SELECT datecolumn 
FROM table
WHERE datetime_date > '2012-05-12 01-32-56'

Upvotes: 5

juergen d
juergen d

Reputation: 204904

 select status_column from your_table
 where added_date < '2012-05-12'

Upvotes: 38

M.I.T.
M.I.T.

Reputation: 1042

try this

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

 SELECT column_name FROM table_name WHERE year(added_date) > $today AND month(added_date) > $today

Upvotes: 1

Related Questions