ok, malopre mi se desilo nesto potpuno spookey. Hteo sam da updejtujem neki timestamp u bazi:
Kôd:
mysql> select * from transact_properties;
+----+---------------+------------------+------------+
| id | site | name | value |
+----+---------------+------------------+------------+
| 1 | neki_sajt | last_search_time | 1182499566 |
i uradim update na trenutni datum minus 10 dana i dobijem
Kôd:
mysql> select * from transact_properties;
+----+---------------+------------------+------------+
| id | site | name | value |
+----+---------------+------------------+------------+
| 1 | neki_sajt | last_search_time | 1189429566 |
provaljujete da sam ubo iste zadnje 4 cifre na oba timestampa ???
e, ali to je tek pocetak, uzmem da proverim timestamp, da nisam nesto zeznuo i dobijem da je datum:
Kôd:
mysql> select FROM_UNIXTIME(value) FROM transact_properties;
+----------------------+
| FROM_UNIXTIME(value) |
+----------------------+
| 2007-09-10 06:06:06 |
666 baby, pa vi vidite