mysql function like time() ?

[akshay]

Hi.

 

Is there any function in mySQL that returns value in seconds elapsed since January 1 1970 00:00:00 GMT, just like time() function in PHP?

 

I've to select * from database where expiry (in seconds) - <...> is less than so many seconds...

 

[note: where <...> is used to represent the function like time() (php) ]

 

Please help.

Thanks

[PravinS]

Try this

 

UNIX_TIMESTAMP(NOW());

 

 

[akshay]

Yea it works!

 

Thanks a lot!

[PFMaBiSmAd]

An even faster version -

UNIX_TIMESTAMP();