I have a Savings table where each row shows a software module, a stakeholder, and the amount of time that the module saves the stakeholder by automati...

I have encountered an odd behaviour of Oracle 23c. As far as I understand lack of the second parameter in the ROUND function should work exactly the s...

I have a table that, minimally, has CREATE TABLE IF NOT EXISTS T ( A int(11) NOT NULL, B date NOT NULL ); A and B themselves happen to have FK...

I'm trying to create a split breakdown of hours worked based on a shift date. Technically we'll be using 2 dates, the start and end date (datetimes) t...

enter image description here im trying to run a query to factor by the date but i cant get it to work. im running this on Oracle. any suggestions woul...

I'm trying to create a Year on Year and Month on Month Calculation using DAX for my Cube. Here's my formula to get Last Month and Last Year: Revenue_L...

How to convert the value in the below input to the format of 9:15 pm, 2nd May 2023 Input: 2023-11-20T17:09:08.000Z What I tried: I tried to use Simp...

I'm relatively early in SQL learning. I have made some data which has records where the date is missing. I want to capture as an output records that s...

I have 2 tables, 1 with TransictionDate_1 & 2nd table with TransictionDate_2. Both tables contain duplicate IDs. I need to match TransictionDate_2 whi...

I have an array that have start_date, end_date and price Eg. /* date formate 'yyyy-mm-dd' */ $existingRanges = [ ['start_date' => '2023-11-22', 'en...

I am trying to rename a set of pdf filenames in the form: "Joe BLOGGS_3052023.pdf" or "Joe BLOGGS_31052023.pdf" ("FirstName SURNAME_dmmyy" or "FirstNa...

This is my script with 2 functions... from jugaad_data.nse import derivatives_df from datetime import timedelta, date from datetime import datetime im...

I'm creating a hotel booking tool for our desk/reception using PostgreSQL 16. To answer booking requests, I need both the total price and the associa...

I'm creating a hotel booking tool for our desk/reception using PostgreSQL 16. To answer booking requests, I need both the total price and the associa...

I have a rangepicker: RangePicker changeOnBlur={true} onChange={horas} disabledDate={datasImp} disabledTime={horasImp} placeholder={["B...

i am trying to show a calendar in order to user choose a reservation date by clicking the reserve button . and the reservation day's date is shown bel...

I store data in the form of year and week in my code (for example 202305 or 202310) in order to do this, I use the Date function in PHP as follows: $w...

How can I use the Date-Fns Adapter for Angular Material to parse short date formats without an explicit separator? For example, 010123 => 01.01.2023. ...

I'm trying to use a compound (multicolumn) index on a table to assist in creating daily report counts. I am using Postgres 13, and my table looks like...

I would like to know if its possible to split a given date range into separate dates ranges if some certain criteria is met? I have two dates start_da...

Server returns date as birthDate: "2023-11-10T05:00:00.000Z" ISO 8601 format. When trying to display this in MUI DatePicker using React-Hook_Form to r...

I'm working on a UiPath automation project where I need to enter dates into a field, but the date format required is YYYY/MM/DD. I want to automate th...

I have these three tables: hotel hotel_id hotel_name room room_id hotel_id room_price room_id date price I k...

I have these three tables: hotel hotel_id hotel_name room room_id hotel_id room_price room_id date price I k...

Let's say I have the following sample input dataframe below. Please note my real table contains hundreds of dates. Date 2023-04-02 2023-07-...