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'm attempting to return the First person to check in in each Room_id by joining the PERSON and CHECK_IN tables http://sqlfiddle.com/#!17/35d930 > Select PostGreSQL 9.6 > Build Schema > Paste Query CREATE TABLE person ("id" int) ; INSERT INTO person…
Is there any difference between these two configs: Config 1: ... environment: - POSTGRES_NAME='postgres' - POSTGRES_USER='postgres' - POSTGRES_PASSWORD='postgres' - POSTGRES_PORT='5432' Config 2: ... environment: - POSTGRES_NAME=postgres - POSTGRES_USER=postgres - POSTGRES_PASSWORD=postgres - POSTGRES_PORT=5432 Because, when I try to docker-compose up with…
I am trying to figure out how to write a single select that would give me all combinations of values for certain aggregations. Let me give you an example of data: COUNTRY PRODUCT VALUE cz p1 5 cz p2 10…
I have a project that is using postgreSQL and Prisma. I was console.logging something in getServerSideProps(), but I noticed that is prisma is automatically console.logging huge amounts of strings like prisma:query SELECT "public"."TaskChart"."id", "public"."TaskChart"."name", "public"."TaskChart"."dateCreated", "public"."TaskChart"."default", "public"."TaskChart"."owner" FROM "public"."TaskChart" WHERE…
I've got a method like this: def transfers(material, capacity, category, created_at) transfers_range = Transfer.first.created_at..Transfer.last.created_at if created_at.nil? Transfer.where( sender_dispensary_id: id, status: %i[dispatched released returned], capacity: capacity, material: material, created_at: created_at.nil? ? transfers_range : Time.given_month_range(created_at) ).or( Transfer.where( receiver_dispensary_id: id, status: %i[dispatched released…
I have this postgresql query SELECT pick.min_date, extract('week' from pick.min_date) as week FROM account_invoice inv left join stock_picking pick on inv.origin=pick.name WHERE inv.number ='INV/2022/17359' and the results are min_date | week 2022-08-11 02:01:00 | 32 What I need for the…
Say I have a varchar column let's say religions that looks like this: ["Christianity", "Buddhism", "Judaism"] (yes it has a bracket in the string) and I want the string (not array) split into multiple rows like "Christianity", "Buddhism", "Judaism" so…
I've got a SQL query that selects every data between two dates and now I would like to add the time scale factor so that instead of returning all the data it returns one data every second, minute or hour.…
I have names table with columns id, name and last_name. So what i'm trying to do is select random name and last_name from it, i tried this: SELECT (SELECT name FROM names WHERE ID =floor(random()* 18 + 1 + x…