Hi, Select unix_timestamp(Now()) - unix_timestamp(datetime_column) from table_name;
At 08:50 AM 29/11/2001 +0100, you wrote: >Hi > >Could i in some way find out the seconds between to datetimes > >I.E. >I have a DATETIME in a table and i want to find out how many >second it is from that DATETIME to NOW() > >Does anyone have an idea? > >/Jonas > >--------------------------------------------------------------------- >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 --------------------------------------------------------------------- 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
