Good day. Suppose I have a table with entries: "no matter what", date (DATE). It is necessary to display all entries for a specific day, month, year. let's say for the day so WHERE date = 2016-12-12 . And in a month or a year? On the Internet, one job with functions like DATEADD and the like.

  • date between '2016-01-01' and '2016-12-31' - Mike
  • In general, such questions / answers sea. for example for a month ru.stackoverflow.com/questions/484446/… - Mike
  • @MIke, empty set, although the record exists - up-and-coming
  • And on the test everything works sqlfiddle.com/#!9/8003be/1 so I don’t know what you have there for the data, in what type of data the date is stored. But without seeing your data, it’s not so impossible to say what you have - Mike
  • the table has id (int PK), item (name), date (DATE); - up-and-coming

0