CODEWITHSUNDEEP
postgresql
Perk8
Perk8

Reputation: 63

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.

Upvotes: 0

Views: 66

Answers (2)

Anand Sowmithiran
Anand Sowmithiran

Reputation: 2920

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.

Upvotes: 1

eshirvana
eshirvana

Reputation: 24633

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'

Upvotes: 3

Related Questions