How to get data from database of a specified date?

  • Hello,
    I want to make a function in php by which I can get data from SQL of a specified date.
    for example I want to get data between 01-oct-2022 to 01-nov-2022

    How to do this? any ideas?

Viewing 1 replies (of 1 total)

  • Something like…

    SELECT * FROM table_name WHERE date_col >= '2022-10-01' AND date_col <= '2022-11-01'

    Of course, you will need to set up your own table and column names to suit your DB table, but you’re really only just using the date column as a search criteria.

Viewing 1 replies (of 1 total)
  • The topic ‘How to get data from database of a specified date?’ is closed to new replies.