20. 09. 2007. | #1 |
Ivan Dilber
Sir Write-a-Lot
|
the number of the beast
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 | Kôd:
mysql> select * from transact_properties; +----+---------------+------------------+------------+ | id | site | name | value | +----+---------------+------------------+------------+ | 1 | neki_sajt | last_search_time | 1189429566 | 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 |
__________________
Leadership is the art of getting people to want to do what you know must be done. |
|
|
Slične teme | ||||
Tema | Početna poruka teme | Forum | Odgovori | Poslednja poruka |
Wire transfer routing number? | Gargoyle | e-Business | 2 | 01. 08. 2009. 19:46 |