skip to Main Content
SELECT
scheduling_appointment.scheduling_datetime
FROM
scheduling_appointment

I need to include a WHERE statement to pull only dates within the last week, but the date and time are in the same column:

2020-12-01 09:30:00-06
2022-09-12 08:00:00-06
2021-02-22 10:30:00-06

How can I do this? I don’t think a LIKE statement would work.

2

Answers


  1. Assuming your scheduling_datetime column is of type timestamp, you can query like below,

    SELECT * from tblname WHERE
    scheduling_datetime between now() + '-1 week'::interval and now()
    
    

    This will return you the records where the date part of your column is falling within last week.

    Login or Signup to reply.
  2. assuming the datatype is timestamp , you can simply compare it.
    not sure wha’s the problem you were facing:

    SELECT *
    FROM scheduling_appointment
    WHERE scheduling_datetime >= current_date  - interval '7 days'
    
    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search