djmartins Posted April 10, 2006 Report Share Posted April 10, 2006 Man ir row ar nosaukumu time kura glabajas 1144670218 <-- laiks.Tagad vajadzetu vinu izvadit (tas nebutu problemas) Bet vajag izvadit taa lai sie skaitli parversas normala laikaa.Ceru ka domu sapratat. Link to comment Share on other sites More sharing options...
v3rb0 Posted April 10, 2006 Report Share Posted April 10, 2006 date('Y-m-d H:i:s', $timestamp); Link to comment Share on other sites More sharing options...
Blitz Posted April 10, 2006 Report Share Posted April 10, 2006 date('Y-m-d H:i:s',strtotime($timestamp)); liekas ka saadi bij precizaak... Link to comment Share on other sites More sharing options...
GedroX Posted April 10, 2006 Report Share Posted April 10, 2006 v3rb0 taisnība, ja time tiek atgriezts ka unix timestamp, kā no jautājuma var noprast. Link to comment Share on other sites More sharing options...
litt Posted April 10, 2006 Report Share Posted April 10, 2006 SELECT DATE_FORMAT(FROM_UNIXTIME(laika_lauks), '%d.%m.%Y') AS datums FROM tabula; Par sintaksi neatbildu, bet idejiski tā 100% strādā Link to comment Share on other sites More sharing options...
andrisp Posted April 10, 2006 Report Share Posted April 10, 2006 date('Y-m-d H:i:s',strtotime($timestamp)); Šis nestrādās UNIX TIMESTAMP gadijumā. strtotime -- Parse about any English textual datetime description into a Unix timestamp Link to comment Share on other sites More sharing options...
Recommended Posts