>I know this is not a toughy, but it has been a long day and my brain is refried. So here goes.
>
>Is there a one-liner someone has that can determine when to show records created over the last 24-hour time period only?
>
>I am saving the DATETIME() in each record and want to list only the saved records that are less than 24 hours old.
>
>What do you think? Thanks for helping me with this TIMEly question.
Select * From Mytable ;
Where mytable.datetime>datetime()-24*3600
Edward Pikman
Independent Consultant