Cacher is the code snippet organizer for pro developers

FROM_UNIXTIME(timestamp,'%d.%m.%Y') #Gibt ein schön formatiertes Datum aus

#Build an automated CURENT_TIMESTAMP to UNIX-DATE converter by using a TRIGGER
CONVERT CURENT_TIMESTAMP TO UNIX-DATE SET NEW.date = UNIX_TIMESTAMP(NOW())