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