Posts by Fernando Leal • 9 points
2 posts
-
0
votes1
answer12
viewsA: How to convert a string to number in SQLITE 3 ? Example: How to convert 2020/2 to 2020?
I got something: Select substr(periodo,1,4)||.0/10 as "periodo_numero" from TabelaPeriodo Where periodo_numero < 2014
sqlite3answered Fernando Leal 9 -
0
votes1
answer12
viewsQ: How to convert a string to number in SQLITE 3 ? Example: How to convert 2020/2 to 2020?
How to convert a string to number in SQLITE 3 ? Example: How to convert 2020/2 in 2020 so that when using the condition WHERE periodo < 2014 will return only periods shorter than 2014?
sqlite3asked Fernando Leal 9