Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ajuly
  • Order by date
  1. ajuly

    Selecting records based on month/year

    Thanks rudy, this is the solution. I don't know whether it has something to do with the server set up but this is what does the job: [code]... where datefield < concat(yyyy,'-',mm,'-','01')[/cpde]
  2. ajuly

    Selecting records based on month/year

    Thanks for the reply guys. Actually my task is a bit trickier: I need to select all the records prior to the selected month (and year), not including the month. SELECT * FROM table WHERE YEAR(datefield)<2004 and MONTH(datefield)<3 would work for February 2004 but not December 2003 (as any other...
  3. ajuly

    Selecting records based on month/year

    This is probably a very simple question, so I am hoping someone has an easy answer. I have a table of records with a date field in M/D/Y format. How do I select all the records for the month (and selected year)? Thanks in advance
    • ajuly
    • Thread
    • Replies: 7
    • Forum: MySQL

Part and Inventory Search

Back
Top