Refactor time convertion from postgresql to php. In my software I had the next question: choose appointment.doctor_id, appointment.date, date_part(‘epoch’,appointment.date::DATE + schedule.time_zero – INTERVAL ‘2 hours’)::INT AS date_that_should_have_booked_in_unix_time from appointment be part of schedule on appointment.schedule_id = schedule.id order by date asc Enter fullscreen mode Exit fullscreen mode With the question above I retrieve the overbooked…

Read More