Questions tagged [datetime]
A DateTime object in many programming languages describes a date and a time of day. It can express either an instant in time or a position on a calendar, depending on the context in which it is used and the specific implementation. This tag can be used for all date and time related issues.
datetime
71,225
questions
3
votes
3
answers
56
views
How do I convert milliseconds to minutes and seconds?
I want to convert milliseconds values in my data to minutes and seconds (in the format MM:SS e.g. a value of 1772094 should become 29:32).
The toy data looks like this:
df <- data.frame(
ID = c(&...
- 562
-2
votes
3
answers
45
views
Numeric string to datetime conversion in C# Winforms application
I'm getting a date value from XML in string (numeric). I want to convert the value like 72124 to 7/21/2024.
Then further I have to assign 7/21/2024 to a string variable.
Please help
0
votes
2
answers
21
views
Laravel Carbon (How to calculate exit next payment date)
I need to get exit next date of payment of loan:
as loan date: 1-1-2020
loan period: 2 years 5 months
payment date: ? ?
calculating expected date of payment
// calculating next payment date
...
0
votes
0
answers
42
views
Pandas reads inconsistent date formats from Excel files generated by PDF4me API
I'm using the PDF4me API to convert PDF invoices into Excel files. The dates are read correctly by the API. However, when I open the Excel files, the dates are displayed inconsistently:
Some dates ...
0
votes
1
answer
44
views
Filter datetime column with object as data type in python
I have a df with a Timestamp and Value columns. Both have the 'object' dtype
| Timestamp | Value |
--------------------------------------
| 8/21/2023 12:00:00 AM | a |
| 11/...
0
votes
0
answers
23
views
R: Creating Continuous Age in Years from DOB and Survey Date [duplicate]
I am currently working in R and trying to calculate continuous age at the start of specific surveys. I have two columns: START and DOB.
START DOB
5/26/2024 10:33 10/25/1991
7/...
0
votes
0
answers
22
views
RTC module current timestamp has truncated seconds
I have a simple bit of C (Arduino) code which uses a non-blocking interval timer to compare two different timestamp values to determine weather or not a specific interval x has passed, if so, then ...
0
votes
0
answers
27
views
How can you use axvspan to show missing datetime data?
I am plotting data showing the water surface elevation of a creek over a 16-year time span. The data are provided in 15-minute increments, but there are missing time periods, including one that lasted ...
- 556
0
votes
2
answers
23
views
using POSIXct to try and clean datetime cells in a table
I am trying to clean some tables in r and I have two columns that are in date time value. I know that date time value cells are difficult to deal with. Part of my problem is that the cells are mixed ...
- 1
1
vote
0
answers
24
views
How to filter Microsoft Outlook emails using a specific date range?
I'm fairly new to Python and have been using it to make things at work easier for me. I work in I.T. and have to read through a lot of emails to look at the status of different things. One of these is ...
- 49
2
votes
1
answer
56
views
Why is the DateTime with specified culture ´nl-NL´, written in culture that is set by the browser?
In Blazor Wasm, I use the following code to write today's date in LongDatePattern to the console. It works well for English, German, Spanish and French. But for Dutch, it writes the date in the ...
- 503
0
votes
1
answer
20
views
Calculate day difference between one date and multiple dates in the same column
I have an input table like this
date
amount
2011-01-02
50
2011-01-03
40
2011-01-04
20
2011-01-05
10
Am looking to group it and create a one-to-many where the difference of date A1 is compared to ...
0
votes
0
answers
11
views
mysql current_timestamp format as MM-DD-YYYY HH:MM:SS ? in an insert into? VBNET [duplicate]
I might want to insert the current date time into a MySQL datetime column using the format as described in the question title.
Not as YYYY-MM-DD
I don't know if this is done or your supposed to format ...
- 21
-1
votes
1
answer
43
views
Create TimeLine field with PyQt5
I need to develop a program to enter time reports. What I do is very similar to time graphics.
I was only able to implement scaling, shuffling and pseudo-infinity fields. The main task is to somehow ...
- 1
0
votes
1
answer
47
views
What is the meaning of: Pandas data cast to numpy dtype of object. Check input data with np.asarray(data) and how can be solved?
I'm trying to model a time series for a stock price with the following code:
import opendatasets as od
import numpy as np
import pandas as pd
import plotly.graph_objects as go
from plotly.subplots ...
- 201