ray Posted April 16, 2009 Report Share Posted April 16, 2009 man ir šāds vaicājums SELECT DATE_FORMAT(date,'%Y-%m') AS date2 FROM table problēma tāda, ka datu bāzē lauks `date` datumu glabā kā integer skaitli (piem. 1239867089). vai ir iespējams kaut kādā veidā izmantot DATE_FORMAT priekš datuma, kas saglabāts iekš db kā integer? Quote Link to comment Share on other sites More sharing options...
bubu Posted April 16, 2009 Report Share Posted April 16, 2009 Ja tas integer skaitlis ir unix timestamps, tad tev jālieto FROM_UNIXTIME funkcija. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.