Questions tagged [date]

A date is a reference to a particular day represented within a calendar system, and consists of year, month and day. Use for questions about creating, manipulating and storing date information. Use with any relevant language tags.

72,972 questions
1vote
1answer
35views

max date value from one column in comparison to another date field partitioned by id SQL BigQuery

I need to create a custom_key field that is a concat of date plus id columns. Each of the custom_key should hold a value in another column. This value is a max date from last_edited_date partitioned ...
0votes
1answer
25views

SQL Query to copy field and split in to 2

hi I'm new to sql im trying to copy a field in SQL table to then split the date and time out Column name :- DocumentDate date I want to split:- 2020-02-12 00:00:00.000 into a new field called DATE , ...
1vote
1answer
23views

Can't convert timestamp to date properly in Javascript

I use mongodb as my database and in that db I have a timestamp field but I haven't seen any format similar to that. Some of them are: 1657479170.7300725 1657479170.7301126 1657479170.7301197 ...
0votes
1answer
50views

Is it a bad idea to use DateTime.MinValue / MaxValue in unit tests?

I'm writing some unit tests, which use some objects with date properties that I need to set. Instead of defining my own hardcoded dates, I've been using DateTime.MinValue and MaxValue. I've heard unit ...
0votes
2answers
14views

How to remove default selected date in Calendar @material-ui/pickers?

I am using the calendar in my project https://material-ui-pickers.dev/demo/datepicker. When I open the calendar by clicking a textbox for the very first time, I don't want today's date to be selected ...
0votes
2answers
32views

Sum up column between two dates, group by 3 columns - MySQL

Can someone please suggest a way to sum up the "count" column between two dates and group it according to the "mcc", "partner" and "result" columns. "Stats&...
-1votes
0answers
14views

Pandas Grouping over specified time span

I have a pandas DataFrame object of this structure: patient_id charttime stoptime value 000000001 2141-07-09 01:34:00 2141-07-09 01:36:00 95 000000001 2141-07-09 01:35:00 2141-07-09 01:36:00 92 ...
0votes
2answers
29views

Is there a way to sort month and year string in google sheet or presto sql?

I have data that looks like this: campaign_type marmay2022 janmar2022 mayjul2022 I'm trying to sort it based on the year and the first 3 character according to the month and year.
0votes
0answers
19views

How to repeat 12 rows of data (which each represent the number of days for a certain month), then add it at the end (after repeating it 100 times)?

NAMES h1281428 h2269417 h2270418 h2271419 h2272420 METHOD LINEAR BEGIN TIMESERIES #days h1281428 h2269417 h2270418 h2271419 h2272420 0 3000.00 3000.00 3000....
0votes
0answers
8views

Moment is not returning result as expected with isAfter method

Something as simple as this is not giving me the expected result .I hope anyone can help. var fecha1=moment(2022-07-02,'YYYY-MM-DD') var fecha2=moment(2022-07-15,'YYYY-MM-DD') console.log(fecha1....
0votes
0answers
25views

Formatting in Python with matplotlib and datetime

I have lots of data to display in time as x-axis (mm:ss or hh:mm:ss). X-axis are shown below: >> print(df0.iloc[:, 0]) 0 0.000000 1 0.500000 2 1.000000 3 ...
0votes
0answers
23views

User defined function interprets date differently depending on whether I reference a cell or enter the date manually

I have a user defined function with 3 parameters. The first 2 are dates and the third the type of inputs I want to reference for further calculations. If I try to use the function by reference the ...
-3votes
0answers
22views

Need to display current date and time using Javascript. Please help...what am I doing wrong? [closed]

Weather App Let me know if you guys can see this. I could not figure out how to post my code on here without the error messages.
0votes
0answers
9views

There's any way to format the Locale obj that comes from Date-fns into ISO 639-1 Code?

I'm using a Date-fns function to calculate the time that has passed since a certain action was executed, the app that I'm working in has two languages available: English and Spanish. here's the code: ...
0votes
1answer
36views

ZonedDateTime localized format

I want to display ZonedDateTime in format like 11.10.2022 13:30 (GMT+2) / 11.10.2022 01:30 PM (GMT+2) depending on device settings. So far I have done something similar using formatDateTime function ...

153050per page