Postgresql get matched line of joined table
I have a table where we have partners and orders are set. |partner_id|order_id| | -------- | ------ | |1 |5 | |1 |6 | |2 |7 | |4 |8 | |4 |9 | |4 |10 | Here we have a…
Postgresql get average period from a table with different partners and purchase days
So basically I have a table where are partners and the dates when then they did their orders. partner_id order_date 1 2022-01-02 1 2022-01-20 2 2022-02-20 4 2022-01-15 4 2022-01-17 4 2022-01-30 And I want to have an information of…
Javascript – Handling monthly recurring meetings on the same day of the week within the same week of the month
I'm facing difficulty handling monthly recurring meetings in my application. The requirement is for these meetings to consistently fall on the same day of the week within the same week of the month, regardless of the specific date. For example,…
Postgresql – error returned more than one row from function
My first post in Stackoverflow. I am trying to learn Postgresql (12) "on the job" and seem to be stuck on a rather simple issue. I have a simple database with 12 rows. In one column (int) there is a…
What is the avg session length in PostgresSQL?
I need some help. I have a table in PostgreSQL with logs of user sessions. The table has 3 fields: id, action, and action_date in the timestamp format. The action field has 2 possible values: "page_load" or "page_exit". The action_date…
Postgresql – SQL Query for "Usage" in 15 minutes intervals
I have a digital Meter. This digital Meter puts it's metering Data into a (Postgres) Database. The relevant Data looks like this: timestamp, total_m3 Every few seconds to minutes, I get the Data logged into the Database. So every 15…
Mysql – Round timestamps to the nearest half hour without omitting missing data
Situation: Imagine some script that, upon completion, inserts the current timestamp and some other data into a MySQL table. It's executed every thirty minutes, sometimes not at all, leaving gaps in the data. Goal: Have a query that fetches all…
PostgreSQL Transition: Comparing Timestamps to days
I am currently transitioning from an older version of SQL Server to a PostgreSQL environment. I am having trouble finding a way to compare a timestamp's age to a set value. This is in the where clause as the goal…
Evaluate a date format from a String value – Mysql
I have a requirement where a filed value is "CAH132242F0A" from this i have to come up with a date. so here "13" is the year and so yyyy = "2013" and "224" th day. so i have to extract…
MYSQL to default the end date based on previous week's last date
How do I go about making the in_date's end date always based on the previous week's last date? For example today is 24 April 2023, and the previous week's (Mon to Sun) last date was 16/04/2023 Expected SQL Query: SELECT…