mardi 3 mars 2015

how to get a custom DateTime format of a column of type DateTime in SQLITE

i have a column InsertionDT of type DateTime('now') what i want is to select this column but only displaye the Time (without date)



select strftime('%H:%M:%S',DateTime('now') ) AS MSGDT from TableA //this works
select strftime('%H:%M:%S',Insertiondt) AS MSGDT from TableA //this is what i want

Aucun commentaire:

Enregistrer un commentaire