Hi everyone,

I have a database in which prices of stocks are stored daily. A program has been written to download the latest prices everyday and update the database with a timestamp stored as date stating when a price was last updated.

I would like to do a select statement which will show me all prices which havent had any new updates in the last 48 hours. How do I do this calculation on a date field using SQL?

Thanks, John