SQL problem - only select data from the future

[martincrumlish]

Hi,

I am accessing a database that has a number of fields including a field called stdate which stores a date in the format YYYY-MM-DD and another field called sttime which stores a time in the format HH:MM:SS

I have a query to select data from this table but I need to modify it so that it only displays data from the future, that is, data where the stdate and sttime values are ahead of the current datre and time.

Any help is appreciated.

Thanks,
martin

[nemonoman]

SELECT *
FROM mytable
WHERE stdate > CURRENT_DATE()
AND sttime>CURRENT_TIME()

[martincrumlish]

thanks