Jump to content

Robbiez

New Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Robbiez

  • Rank
    Newbie
  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.