Re: [GENERAL] JOIN and difference between timestamps

2008-03-07 Thread Scott Ribe
I understand that subtraction of timestamps will return an interval, but I cannot tell if it is in seconds or minutes. Neither. Because an interval can represent things like '1 year' or '1 month' which cannot be represented as a simple number of seconds or minutes. So what you want is:

[GENERAL] JOIN and difference between timestamps

2008-03-05 Thread Conor McTernan
I'm trying to find a count of records based on a number of factors, one of them being that records in different tables have been created within 1 hour of each other. The tables in question look like this: character_tbl Column |Type | Modifiers