Jump to content


New Members
  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Robbiez

  • Rank
  1. HI Can anyone help with a statement to select all rows from a table where the value of a column is earlier than today's date. The date is stored as(for example) Monday 1 March %W %e %M I was hoping something like this would work: SELECT * FROM `table` WHERE DATE_FORMAT(dispatchdate, '%W %e %M') < NOW()-INTERVAL 1 DAY Thanks
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.