330 questions
3 votes
2 answers
225 views
Failure to parse a date with the DateTime.TryParseExact() .NET method
Am getting errors when executing powershell script.I got folders on the name of date DD MMM example 01 May,02 May go on to 31 May.I want to get the name of the folder 01 May covert it to 01 May 2025 ...
0 votes
1 answer
36 views
no leading zero in hours h:mm:ss time format to convert to seconds in a derived column in SSIS
a source flat file has duration columns in :00:00 format as well as 0:00:00 format. Trying to convert to seconds when there's no leading zeros in the hours. Sample of the Source file when viewed in ...
0 votes
0 answers
70 views
Date conversion not working properly in flutter app on release version
Date conversion in debug mode working fine in my flutter app but on release version its showing different values, even when I tried to show the exact value what was in Firestore on release version its ...
-3 votes
1 answer
116 views
LocalDateTime Conversion [duplicate]
I am trying to convert current date and time with the help of LocalDateTime java class and then trying to store it in Database table column having Date datatype. Below is the code , i am trying to ...
2 votes
2 answers
2k views
Unable to obtain Instant from TemporalAccessor: {},ISO resolved to 2024-04-25T14:32:42 of type java.time.format.Parsed
I've below java program which converts string to Instant object. import java.time.Instant; import java.time.format.DateTimeFormatter; import java.time.temporal.TemporalAccessor; public class ...
1 vote
1 answer
41 views
How to convert UTC to EET in ggplot2 geom_segment chart?
I'm trying to adjust the UTC time into EET time in a gantt type of chart, where I want to plot some Cron schedulings which are in the UTC time. Here is the code. How can I adjust the time conversion ...
-3 votes
1 answer
85 views
How do I fix the error while trying to use datetime.strptime to convert a string to a datetime object? [closed]
date_str = "2024-04-19 15:30:00" datetime_obj = datetime.strptime(date_str, "%Y-%m-%d %H:%M:%S") I attempted to convert a string to a datetime object using the datetime.strptime() ...
0 votes
0 answers
57 views
Convert military time in varchar format to standard time
I am working with a table that stores times in military format as varchar(6). I need to display and calculate durations. How can I show for example 1015 as 10:15 and calculate 1015 - 30 getting 09:45 ?...
4 votes
1 answer
2k views
FutureWarning: Support for nested sequences for 'parse_dates' in pd.read_csv is deprecated. How to combine date and time columns with pd.to_datetime?
Here is an example of my .csv file: date, time, value 20240112,085917,11 20240112,085917,22 I used to import it to DataFrame with the following way: df = pd.read_csv(csv_file, parse_dates=[['date', '...
0 votes
0 answers
71 views
T-SQL Convert UTC time from cloud server to local time with daylight savings
I have an Azure cloud SQL DB located in UTC timezone, but I'm located in Central Europe with daylight savings half of the year. In an ETL process I use GETDATE() to fill a column to tell me the last ...
0 votes
0 answers
53 views
Error with Dynamic SQL Data Transfer: Operand data type nvarchar is invalid for subtract operator
I need to transfer data between tables in a database. The issue is that the old table uses a 6-character format (YYMMDD) for dates in the "RecordDate" column, whereas the new target table ...
4 votes
2 answers
217 views
DECLARE vs. Direct DateTime Conversion Performance Comparison
I am trying to understand if there is any performance difference between declaring a datetime conversion variable and using it versus directly converting the date in a SQL Server query. Here are two ...
1 vote
0 answers
80 views
Converting date to tick when the date has a time as 00:00:00 results in previous days tick
I have a date as Sun Oct 01 2023 00:00:00 GMT+0530 (India Standard Time) which i'm trying to convert to the time tick as below overlapDetails is an array with data as [{start: Sun Oct 01 2023 00:00:00 ...
0 votes
1 answer
228 views
How to get timezone from local and UTC timestamps java
I have a use case where the data coming as input does not specify the timezone, however we have two separate fields "local" and "utc", which can in practice denote the offset, and ...
0 votes
3 answers
326 views
Converting remainder of modulus to minutes
I have included my code below, Trying to take a speed from the user and a Distance they need to travel and calculate how many hours and minutes the trip will take. But my minutes keep on displaying 0, ...