I have a database called dx_data. There is a field in it called dx_dati that is a date and time field. As a user enters a record in the database, this field is stamped with the system date & time.
What I require is a query to list all the records in the database that are within 30 minutes of the current system time. I am using a Postgres database (fairly new version).
Okay, I can see where this may be a problem with postgres. Not sure why, but maybe there is a simpler work around.
Would it be easier to have a query where I get a listing of the most recent 25 entries in the database?