Advanced Search

Unix Timestamp mit MySQL Formatieren

/ Published in: MySQL
Save to your folder(s)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.