All Questions
3,187
questions
-2
votes
2
answers
32
views
Calculate the time a user has been offline - React JS [closed]
I want to calculate the time the user was offline.
I'm creating a mining app and I want the mining to continue even if the user is offline, I save the date to localStorage every second to be able to ...
0
votes
0
answers
43
views
pd.Timestamp() behavior in Pandas
Trying to understand why t1 takes current date whereas t2 takes the epoch date in Pandas in Python. Any thoughts would help.
import pandas as pd
t1 = pd.Timestamp("23:12:05")
print("t1:...
0
votes
2
answers
85
views
add date columns
I have two columns with date and I need to create another based on sum of those two. df looks like below:
date_1 date_2 result_date
2024-07-07 18:00:00....
1
vote
0
answers
28
views
PrismaORM shifting the UTC time from my db to the timezone of my nestJs application
I have records with timestamp fields in mySql DB. Like this: 2024-06-26T19:00:00.000Z
But when I retrieve these records with prisma, they are converted back to my timezone, so the UTC time in database ...
0
votes
0
answers
32
views
Adding elapsed time in seconds to an approximate date in Excel over multiple datasets in a single sheet
I am not super great at Excel, have never ventured into VBA, don't know how to do macros, and have very, very limited programming knowledge, so please excuse my ignorance. I have a bunch of data in ...
2
votes
2
answers
75
views
Sum POSIXct POSIXt values from a column
I have one data frame with more than 1000 rows, and I have one column duracao which I want to sum the values that have there HH:MM, and resulting also the value as HH:MM.
df <- data.frame(duracao = ...
0
votes
1
answer
45
views
How can I modify this script to select any folders dated in the last 12 months?
I have a folder directory (shown below) that contains folders titled "year-month." They will be continuously added over time. I am trying to write a python code that selects any files in ...
0
votes
0
answers
54
views
Repeat python function with precise time stamp
I have a task to communicate with a hardware with reasonably high precision (1pps) to simulate telemetry data collection. Based on StackOverflow and other sources I was able to come up with the ...
1
vote
3
answers
48
views
Calculate time in the future and get timestamp from it python
I want to create /giveaway command which calculates actual time + time that giveaway will last and get timestamp from this time in the future
i tried to do this but i get date 1970 year
hours = 2
...
0
votes
1
answer
37
views
Is there any function extracting DD/MM/YY HH:MM:SS in BigQuery to hh:mm:ss?
In the bigquery-public-data.new_york_taxi_trips.tlc_yellow_trips_2022, the dropoff_datetime and pickup_datetime are in DD/MM/YY HH:MM:SS format, and I want to find pickup_location_id and subquery....
1
vote
1
answer
66
views
Determine if a value is earlier or later than time
I have the following data:
times <- c("20:00","17:00")
df <- data.frame(times)
df$times <- as.POSIXct(df$times, format = '%H:%M')
Now, I would like to create an extra ...
0
votes
1
answer
71
views
How to handle "generic" time in Dart? (not tied to specific date)
My app matches users for a specific hobby. For that, users usually need to agree on a regular meeting time. For example "every Friday from 6pm to 10pm".
Storage wise I think I will go with a ...
1
vote
2
answers
67
views
Finding Next Available Datetime Combining Weekly Schedule and Special Days in PHP
I'm working on a PHP project where I need to calculate the opening times for a business, which includes both regular weekly schedules and special non-standard times for holidays. I have two arrays: ...
0
votes
0
answers
28
views
Is there a better way to create a time series? [duplicate]
GFY2018 = pd.date_range("10-01-2017", "9-30-2018")
GFY2019 = pd.date_range("10-01-2018", "9-30-2019")
GFY2020 = pd.date_range("10-01-2019", "9-30-...
0
votes
1
answer
16
views
Time minus time geting only hours, not days [duplicate]
having some kind of problem and dont know how to fix it, ok imagine
my code:
$row2['from'] = 2024-04-03 09:00:00
$row2['till'] = 2024-04-04 21:00:00
$datetime= strtotime($row2['from']) - strtotime($...