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
Assuming your scheduling_datetime column is of type
timestamp
, you can query like below,This will return you the records where the date part of your column is falling within last week.
assuming the datatype is timestamp , you can simply compare it.
not sure wha’s the problem you were facing: