Posts by Leandro Amorim Viersberg • 37 points

• 1

  votes

  2

  answers

  58

  views

  A: Data conversion in SQL server after using in Where clause?

  For date formatting, I used convert(varchar(10),po.DueDate ,103), and to the where used where po.DueDate between '01/04/2011' and '30/04/2011'. The query was like this: select pp.productID, pp.Name…

  sql sql-server datetime select-sql

  answered 3 years, 3 months ago Leandro Amorim Viersberg 37

• -3

  votes

  2

  answers

  58

  views

  Q: Data conversion in SQL server after using in Where clause?

  I need to extract sales from such a date period until such date. For example, between 01/04/2011 and 30/04/2011. I am not able to bring the result of the period in question. In this case, I am using…

  sql sql-server datetime select-sql

  asked 3 years, 3 months ago Leandro Amorim Viersberg 37