Re: Date Differance in MySQL

2001-11-29 Thread Anvar Hussain K.M.
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

Date Differance in MySQL

2001-11-28 Thread Jonas Jonsson
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,