Posts by tcm • 41 points

• 4

  votes

  3

  answers

  75

  views

  Q: How can I exclude the penultimate number from a period?

  I’m trying to leave the period from 201601 to 20161 in SQL, but I can not at all! I wonder if someone could help me? SELECT CONVERT(NUMERIC(5), CONVERT(VARCHAR(4), YEAR(Periodo_Mensal))+…

  sql database sql-server

  asked 8 years ago tcm 41