My Table has timestamp in 'MM\DD\YYYY HH:MM:SS' format but its varchar. How can I get last 7 days data. I know in SQL Server its easy but not able to acheive this in SQLite Could you guys help out here ?
Hey bandi , what I missed is timestamp format is MM\DD\YYYY HH:MM:SS AM\PM' format which is not supported as timestring in the sqlite datetime functions
Hey bandi , what I missed is timestamp format is MM\DD\YYYY HH:MM:SS AM\PM' format which is not supported as timestring in the sqlite datetime functions
Avinash -QA(Automation)
Then use REPLACE('MM\DD\YYYY HH:MM:SS', '\', '-') function to get supported format...
Playing with dates in SQLite
Posted - 10/11/2012 : 08:00:46
