> > 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 WEBSESSIONS; > > > > What leads you to expect that this should yield any useful result? > According to the documentation of the NOW() function: "Returns the current date and time as a value in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS format, depending on whether the function is used in a string or numeric context" Assuming SESSIONTS is of type TIMESTAMP, "SELECT (NOW()-SESSIONTS)" should return the differences in seconds.... But it does not, in fact I can not determine what MySQL is returning, it does not appear to be any accurate measurement of time. Troy
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.431 / Virus Database: 242 - Release Date: 12/17/2002 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php