Subject | Days since timestamp |
---|---|
Author | Nigel Weeks |
Post date | 2006-05-26T00:49:57Z |
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
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