Category "date"

Combining cte with dates and table with dates between two dates

I have a few pieces of code that give me things that I need, but I need some help for put them together. I have: create table #test ( job int, dateL date) inser

Date.getTime is not a constructor [duplicate]

In a function I have the line: const currentTime = new Date.getTime(); The code compiles just fine. Also, ESLint displays neither warnings or

Create a date object in a specific time zone and convert it to UTC in JavaScript

My application is currently storing the date and time of a particular event in the following format: date: 2022-05-06 time: 00:00 // (12:00 AM) Each event's ti

How to convert a date string with optional fractional seconds using Codable in Swift?

I am replacing my old JSON parsing code with Swift's Codable and am running into a bit of a snag. I guess it isn't as much a Codable question as it is a DateFor

How to convert YYYYMM to YYYY-MM datetime format without day?

I have two datasets that have monthly frequencies. For one of them,df, I had to aggregate some data to turn it from daily to monthly using the following code: d

Expanding dataset and filling missing dates in Pandas

The raw dataset is below: DF When the start and end dates differ, we require daily granularity. Daily granularity ensures each row has the same start and end d

Convert date and time in dart [duplicate]

from API I am getting this: "2022-05-12T15:55:03.000000Z" My question is, how can I make it: 12.05.2022, 15:55 My question is, is here any eas

Why i get added 5 hours instead 4 on daylight saving time when i use the add method and how can i resolve it?

I need to add 4 hours to my moment js date. So for that i am using /* this timestamp is this date 27-03-2045 00:00 */ const someday = moment(2374178400000); con

Mysql get end date excluding weekends

in Mysql I am trying to get end date excluding weekends like my function GET_DATE_WEEKDAYS('2022-03-24',5) giving - 2022-03-17 which is fine it is giving issue

How to add random minutes like first slots should be 30 minutes and then 1 of 15 minute slot and again 30 minute slot

const eventClick = (args) => { let StartTime = moment(args?.event?.StartTime, 'HH:mm ') let EndTime = moment(args?.event?.EndTime, 'HH:mm ') if (

convert month of dates into sequence

i want to combine months from years into sequence, for example, i have dataframe like this: stuff_id date 1 2015-02-03 2 2015-03-03 3

PHP | Parse specific german date format to yyyy-mm-dd

Hey I am struggling with a date format . I need to adjust the display of some dates in a wordpress project. Its not a duplicate of This question I tried the sug

PHP: Parse date from localized format

I need to parse a date string in a multi-language application. Every user has their locale and then their date format. How to use: new DateTime($datestr); o

Create a new Date for any specific timezone

I am using Google Apps Script to check and re-format date data from some Google Sheets. But the problem is the result shows the times for the user who run the c

view limit minimum 0.0 is less than 1 with matplotlib

I know there are similar questions to mine below, but mine is minimal and does not have anything to do with pandas and also solution pd.to_datetime did not work

How to formate or validate date in java like 20992012 or 12122022? [duplicate]

i have to validate date yyyyMMdd or MMddyyyy or ddMMyyyy. if i pass input 20221224, ho to make this is valid? but how can i do this in regex

Computing number of business days between start/end columns

I have two Dataframes facts: columns: data, start_date and end_date holidays: column: holiday_date What I want is a way to produce another Dataframe that has

If date is older than 6 months and value is X, then output this

I have two columns in excel, one with a date and one with a rating 'low, medium, high'. I'm trying to write a formula to put in a third column that checks: If A

Add missing dates to pandas dataframe

My data can have multiple events on a given date or NO events on a date. I take these events, get a count by date and plot them. However, when I plot them, my

Subtract the date from each cell in a column, skip cells that have string values

I have an Excel sheet of expiration dates. Some rows lack an expiration date so I chose to fill those cells with the string “NO DATA”. I want to loo