All Questions
5,023 questions
-3
votes
2
answers
160
views
Does Instant.MAX need to be manually formatted? [closed]
DateTimeFormatter fails on valid Instants. How it is meant to format those below and above LocalDateTime.MIN and LocalDateTime.MAX? Manually?
DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"...
- 1,637
1
vote
1
answer
26
views
Format timestamp in php from date to time in fractions
I apologise in advance because this question was most likely asked before, but I can't find it because I am not sure what phrase to use.
I have a date timestamp in php from Unix Epoch format. The ...
- 69
0
votes
1
answer
88
views
Excel does not recognize m/d/yyyy, h:mm:ss.000 AM/PM
How I can make the following date-times recognizable by Excel, at least as a date? They are from Azure and Excel doesn't recognize its own company's date-time format.
9/30/2024, 3:02:59.000 PM
11/4/...
- 9,009
3
votes
2
answers
103
views
Find total length of time in multiple values of a dataset that overlaps with a given period of time
I have a dataframe like the following:
df <- tibble(
period = list(
c("09:34:00-20:40:00", "20:57:00-21:00:00"),
c("16:03:00-19:00:00", "19:10:00-21:00:...
- 637
0
votes
0
answers
36
views
android get time in given timezone ignoring device's current time
I should get the time in my country not depending on in which timezone user is in or which time he set manually from the settings of device.
Below code works when user sets different timezone, it ...
- 2,711
1
vote
1
answer
96
views
How to trigger inline script onload?
I have the following script, as seen, it calls the Date method onClick event, like so:
<!DOCTYPE html>
<html>
<body>
<p onclick='this.innerHTML = Date();'>click me!</...
- 3,142
0
votes
1
answer
140
views
Looker - How to Compare today data with last week data but including hours
I need to find out how to compare today data with last week data in lookerstudio.
Example:
Today 01/11/2024 16.00 PM # of order is 2255
Last week 25/10/2024 16.00 PM # of order is 2190
I need to ...
- 39
0
votes
3
answers
97
views
How to convert a Date to the midday Time in UTC in Ruby-on-Rails, regardless of the timezone?
I have a Date instance in Ruby-on-Rails. I would like to convert it into the midday in Time in UTC.
How can I do it?
I thought this would work.
date = Date.new(2024, 10, 20)
time = date.to_time + Time....
- 2,277
1
vote
2
answers
52
views
R, how to get current time miliseconds, without extra information ? (Sys.time(), format("%X"))
I have tried to get just the current miliseconds from the current second in R with the following code:
options("digits.secs" = 6) # since 6 is the maximum digits for seconds apparently
Sys....
0
votes
1
answer
64
views
UTC time from gps ms time in Julia
I'm trying to understand the Logic of converting gps time ms to UTC. The gps time is already utc corrected in milliseconds from LIDAR
I'm not sure how to confirm if this is correct?
time_adj=...
- 566
0
votes
1
answer
52
views
Automatically shows date and time in VBA on multiple columns
As on topic, I want my excel formula automatically shows date and time after key-in it's data on respective cell. I am able to get date and time on column A & B while key-in data on column C. ...
- 33
0
votes
1
answer
138
views
Excel recognizes the "date time" format in the chart but not in the x-axis calculation
I have imported data from my thermostat. The first two columns are "date" and "time" in the d/m/yy and hh:mm:ss formats respectively.
Excel is brilliant and recognized that those ...
- 414
0
votes
1
answer
76
views
Last Sunday until this upcoming Sunday with time
I am trying to retrieve the last recent Sunday at 3 AM until this upcoming Sunday 2:59 AM.
Below is what I have but it doesn't retrieve exactly the upcoming Sunday. Ideally, whenever I run this query, ...
- 79
1
vote
1
answer
52
views
Is there a way to tell whether Date.parse() acted on its own?
I am currently building a database of old Usenet postings (spanning from 1988 to 1999) from which I want to extract the respective time stamps. As expected, there were a lot of non-standard date ...
-1
votes
2
answers
98
views
Handling Time-Only Strings with IsDate in VB.NET
I need to handle cases where a date string could represent a full date and time or just a time. Here's my current code snippet:
Dim InvoiceDate As String = Nothing
If IsDate(strInvoiceDate) Then
...
- 41