posted 19 years ago
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!