Posts by Fernando Leal • 9 points

• 0

  votes

  1

  answer

  12

  views

  A: 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

  sqlite3

  answered 3 years, 3 months ago Fernando Leal 9

• 0

  votes

  1

  answer

  12

  views

  Q: 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?

  sqlite3

  asked 3 years, 3 months ago Fernando Leal 9