mysql - get time interval

[ian dwyer]

hello - this is probably pretty simple, but i was wondering if anyone had seen any examples of how to select something from a database based on a time interval.

for example, i have a number of records in a database, and I want to be able to pull all the ones out that have been created, say, less than one hour from the present time.

what is the best time/date format to stamp these things and what are the comparison methods like?

thanks!

[Sonny Gill]

Hi Ian, welcome to JavaRanch.

This depends on the database you are using, and whether it supports arithmatic operators on date/time values, or has special methods to use with data/time.

In Oracle, you can just subtract two Dates, and it gives you the number of days(or the fraction of a day) between the two, which you can use in specifying your conditions.

The best place to start is the documentation for the database you are using.

Cheers