Return to Snippet

Revision: 34990
at December 5, 2010 02:22 by xnet74


Updated Code
SELECT 
    id,
    art,
    mwst,
    preis,
    FROM_UNIXTIME(bestellung.create_time,'%d.%m.%Y %H:%i') AS createTime
FROM 
    bestellung
ORDER by 
    id
DESC
LIMIT
    0,20

Revision: 34989
at November 1, 2010 01:08 by xnet74


Initial Code
SELECT 
    id,
    art,
    mwst,
    preis,
    status,
    FROM_UNIXTIME(bestellung.create_time,'%d.%m.%Y %H:%i') CreateTime
FROM 
    web6_sql1.bestellung
ORDER by 
    id
DESC
LIMIT 0,20

Initial URL


Initial Description


Initial Title
Unix Timestamp mit MySQL Formatieren

Initial Tags


Initial Language
MySQL