Re: [PHP-DB] Need Help on subtract Time

[Russ Michell]

Kelvin:

If you're using MySQL - go check out: 
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
It has some great little MySQL data and time functions. I have personally found it 
invaluable.

Good luck! :-)
Russ

On Wed, 14 Nov 2001 15:49:03 -0500 kelvin [EMAIL PROTECTED] wrote:

 Hi everyone,
 
 I have a table with those field. ---Username, Uid, and Time.
 Ok, I tried to select data which their time is 2 min less from the
 current time or so.
 
 Could anyone help me out, How to do it?
 
  This is what I got, but doesn't work.
   select * from tablename where time  date(H:i:s,(time()-720));
 
  Please help!!!
 
 Thanks.
 Kelvin
 
 
 
 -- 
 PHP Database Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]
 

#---#

  Believe nothing - consider everything   
  
  Russ Michell
  Anglia Polytechnic University Webteam
  Room 1C 'The Eastings' East Road, Cambridge
  
  e: [EMAIL PROTECTED]
  w: www.apu.ac.uk/webteam

  www.theruss.com

#---#


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

RE: [PHP-DB] Need Help on subtract Time

[Rick Emery]

select * from tablename where time  now() - interval 2 minute

this assumes the field time is defined as TIMESTAMP

-Original Message-
From: kelvin [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 14, 2001 2:49 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Need Help on subtract Time


Hi everyone,

I have a table with those field. ---Username, Uid, and Time.
Ok, I tried to select data which their time is 2 min less from the
current time or so.

Could anyone help me out, How to do it?

 This is what I got, but doesn't work.
  select * from tablename where time  date(H:i:s,(time()-720));

 Please help!!!

Thanks.
Kelvin



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]