Datetime, need help

[thoand]

Hi,
in my app I need to pull out only articles that are not yet published.
eg. select * from article where available not in the future

I record the date with my items with a datetime colum
available: 2003-10-24 00:45:45

can anyone help me out.

best regards Thomas

[[deleted]]

You want to pull articles that have an available date in the future, right? Try this:

select * from table where available > NOW()