RE: RE: NOW()-TIMESTAMP does not return accurate results

2002-12-19 Thread Troy Kruthoff
> > At 23:39 -0800 12/16/02, Troy Kruthoff wrote: > > > >Description: > > > Invalid reporting of date calc > > >>How-To-Repeat: > > > note: SESSIONTS is TIMESTAMP type > > > > > > SELECT (NOW()-SESSIONTS) FROM WEB

NOW()-TIMESTAMP does not return accurate results

2002-12-16 Thread Troy Kruthoff
>Description: Invalid reporting of date calc >How-To-Repeat: note: SESSIONTS is TIMESTAMP type SELECT (NOW()-SESSIONTS) FROM WEBSESSIONS; +---+ | (NOW()-SESSIONTS) | +---+ | 1261 | +---+ 1 row in set (0.00 sec) mysql>