Question 114655 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql WHERE statement when date and time are in the same column

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.

Tags:

2

Answers


  1. 0

    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. 0

    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