advanced code snippet search

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
 
Expand | Embed | Plain Text 
  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.