Subject Days since timestamp
Author Nigel Weeks
I'm pulling out my hair here...(what's left, anyway...)

Table:
CREATE TABLE tbl_event (
int_event INTEGER NOT NULL,
dtm_stamp TIMESTAMP,
PRIMARY KEY(int_event)
);

How do I work out how many days(relative to 'now') it's been since an event
happened?
I've got 7 levels of parenthesis and casts/extracts, and I'm getting
grumpy!!!

There's got to be an easier way!

N.

Nigel Weeks
Tech Support & Systems Developer
nweeks@...
www.examiner.com.au
71 - 75 Paterson Street
Launceston
Tasmania 7250
Australia
Phone: 03 6336 7234