LesOlivex

Serveis informàtics




Formato para fechas unis en sqlite

Category : sqlite des 21st, 2014
SELECT id
,strtotime("%d/%m/%Y %H:%M:%S", datetime(fecha,"unixepoch")) as fecha
,tipo
,mensaje
, "sesion: " || sesion || " " || fichero || ":" || linea || "nn" || descripcion as descripcion  
FROM registros

Leave a Reply

Your email address will not be published. Required fields are marked *