Unix Timestamp mit MySQL Formatieren - MySQL Snipplr Social Repository

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

Choose a language for easy browsing: