Posted By

xnet74 on 11/01/10


Tagged

timestamp


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

virendrakryadav


Unix Timestamp mit MySQL Formatieren


 / Published in: MySQL
 

  1. SELECT
  2. id,
  3. art,
  4. mwst,
  5. preis,
  6. FROM_UNIXTIME(bestellung.create_time,'%d.%m.%Y %H:%i') AS createTime
  7. FROM
  8. bestellung
  9. ORDER BY
  10. id
  11. DESC
  12. LIMIT
  13. 0,20

Report this snippet  

You need to login to post a comment.