need the number of seconds since....

If you need seconds you can use the MySQL DATETIME and TIMESTAMP fields to get seconds also.

TIMESTAMP(4) and DATETIME(4)

The 4 can be change for how many seconds you need.

SEE:

MySQL - 11.3.6 Fractional Seconds in Time Values

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )