SQL Select Question

[xospec1alk]

I have a database that contains a value for the "Due Date"

is there a way to output whether a row is "Overdue" by checking if Due Date < SYSDATE and then creating a new column to hold this boolean data?

i know you can do select (1+1) as overdue....which will create a new column called overdue and populate it with 2...

but i can't seem to get it to work with a logical instead of a mathematical

 

[znaps]

I think you can use a CASE statement for this. There are probably other ways also.

 

[Red Squirrel]

You could use time() as well, so something like mysql_query("SELECT * FROM table where daterow<".time().";");

 

[xospec1alk]

Originally posted by: znaps
I think you can use a CASE statement for this. There are probably other ways also.

w00t, that works great, as you can tell im still a sql n00b.

as for squirrel thx for the tip, i will try that out as well