Questions tagged [date-conversion]
Conversion of dates from one calendar or notation to another, for example, converting Julian calendar February 29, 1700 to Gregorian calendar March 11, 1700, or "March 11, 1700" to "1700-03-11".
date-conversion
701
questions
0
votes
4
answers
103
views
Why does "TimeValue()" Excel worksheet function not work on value "09:21:50.0558"?
I'm working with timestamps, containing milliseconds, like "09:21:50.0558".
According to this highly upvoted answer, the Excel worksheet function should be able to cope with such an input ...
- 17.1k
-1
votes
2
answers
70
views
JavaScript Date object showing incorrect date when set to midnight in UTC
I'm encountering an issue with the JavaScript Date object where it's showing an incorrect date when I set it to midnight in UTC. Here's my code:
function updateDates(startDate) {
var utcStartDate =...
- 113
0
votes
1
answer
60
views
How to convert MJD time in UTC (only date, no time) in order to make a plot
I have a list of MJD time. I need to convert it in list UTC but only the date (year/month/day) and no time, so a list that I can use to make a plot with time in x-axis.
Thanks
I tried with astropy and ...
0
votes
2
answers
49
views
String to LocalDate conversion issue
I have a SpringBoot 2.6.14 web-app with JPA 2.2 and Hibernate 5.
Now I have a String with this format
"2024-03-04T14:10:37.000Z"
And, following some instruction (googling around) I write ...
- 673
1
vote
1
answer
87
views
Convert Dates - Gregorian to Hijri - Bigquery
I am looking to convert dates from my date column in my table from the Gregorian format '12-02-2023' to Hijri (Islamic Lunar Calendar) format '01-03-1445' format.
I would like to later get results ...
- 11
0
votes
0
answers
21
views
Python - possible datetime value issue upon organizing data for dashboard creation/defining KPI metrics
I keep receiving the following error upon trying to run my python code in visual code studio: It seems that there must be some issue with the data type/format of the data I try to convert:
An ...
-1
votes
3
answers
133
views
C Programming : Decimal to Octal
Consider:
// Decimal into octalenter image description here
#include <stdio.h>
#include <math.h>
int main()
{
int num, r = 0, octal, i = 1;
printf("Enter the number you want ...
0
votes
0
answers
9
views
I have configured my FB Conversion API with FB PArtner option ( Available in FB event manager section) my variable saying undefined
enter image description here
it supposed to return the value like product name, currency and value. but it is returning undefined. the total process is done by fb-eventmanager-partner inegration ...
-1
votes
1
answer
67
views
from_unixtime still displaying 19 hours past expected time
I currently have some cleaned data with new columns and formatted correctly, however the clause regarding from_unixtime is stumping me. I have tried the following:
from_unixtime(`time@timestamp`, '%H:%...
- 1
1
vote
2
answers
2k
views
Convert datetime to date format
I am working on dates in a query and am seeing some unexpected behavior. I want to convert a datetime to dd-mm-yyyy format but seem to be unable to get the right result.
On my Dutch machine
I have the ...
- 269
1
vote
0
answers
31
views
How can I convert Julian dates to fit my data ? (eg. January 2nd would be "2" but I need it to be 365 +2 = 367)
so I am trying to look at day of year that ice is freezing in lakes over time.
I have figured out how to convert my dates into Julian days, however, in some years ice-on is happening in the same year.
...
- 11
-2
votes
2
answers
343
views
How to convert Date from 2023-11-10 09:44:00.038860 to 2023-11-10T09:44:20.001+00:00 in spring boot application
I am getting response from ELK and mapping it to an object using ObjectMapper and then return the response as JSON. The ELK response has a Date datatype field with the format yyyy-MM-dd HH:mm:ss....
0
votes
1
answer
23
views
(MySQL) Insert by subquery contains date conversion in the condition
I have the following query:
SELECT 'Wrong DATE format'
FROM DATE_TABLE
WHERE CONVERT(STR_TO_DATE( STATUS_DATE, '%Y-%c-%e %H:%i:%s'), CHAR(20)) \<\> STATUS_DATE;
the column "STATUS_DATE&...
0
votes
2
answers
1k
views
How to convert YYYYMMDD string to date in databricks SQL end point?
How to convert YYYYMMDD string to date in databricks SQL end point?
Input values:- 1. 20230804
2. 20230805
output values :- 1. 2023-08-04
2. 2023-08-05
- 75
0
votes
0
answers
153
views
convert millisecond to datetime in Python
I have a set of data whose time is esper in milliseconds (time.stamp), where each value represent a misure (10 Hz it's the working time of the instrument):
What I want to do knowing the year, month, ...
- 7,634