|
|
Calculate unix timestamp in mysql - Mysql
|
Views : 1328
|
|
Tagged in : Mysql
|
|
|
Report This Scrap as Inappropriate
We request you to choose the appropriate categroy and subcategory that suits your
objectionable concern about the scrap, So that our team can review and find out whether it violates our Guidelines or the
scrap is not suitable for all viewers.
|
Unix Timestamp:
To calculate date/time in unix timestamp in mysql,
mysql> SELECT UNIX_TIMESTAMP();
It results,
UNIX_TIMESTAMP()
1217344347
It will display the unix timestamp value for the current date/time.
To convert the given date/time to unix timestamp,
In mysql prompt type,
mysql> SELECT UNIX_TIMESTAMP('2008-05-22 05:25:45');
It results,
UNIX_TIMESTAMP('2008-05-22 05:25:45')
1211414145
|
|
By - Ramya, On - 2008-07-29 |
|
|
|
