Questions tagged [string-to-datetime]
217 questions
-2
votes
1 answer
pd.todatetime() ValueError: unconverted data remains: 9
Withe the code & data below, first time it don't work and rerurned
File "pandas\_libs\tslibs\strptime.pyx", line 148, in pandas._libs.tslibs.strptime.array_strptime
ValueError: unconverted data remains: 9
Here is my code. Where is the problem?
BTW…
Sean.H
- 640
- 1
- 6
- 18
-2
votes
1 answer
How to improve the memory efficiency of this code?
I am looking for ways to improve my memory hogging code.
The last piece of the following section of code is an attempt to create separate columns from datetime columns. It does work, however, as I type this it is taking 1.2GB of RAM while…
J. Brown
- 1
- 2
-2
votes
2 answers
mysql date comparision is not working unable to find the issue
i have a huge data with dates as string.
column name date1
datatype varchar
the stored data is in this format:14-Mar-2016 05:44:38pm
Now I have split only date from this string like this: 14-03-2016
By using this: DATE_FORMAT(STR_TO_DATE(gr.date1,…
Mr world wide
- 4,696
- 7
- 43
- 97
-2
votes
1 answer
Need to convert string to DateTime format in C#
I have a string stored in table "13/12/1985 12:00:00 a.m." when i tried to convert this to Datetime, i am getting an exception saying "String is not a valid DateTime Format". It is because the first part of the string(13) is month. Is there any way…
user3403111
- 65
- 2
- 9
-2
votes
1 answer
String to date not working properly
I am trying from half an hour to convert string to date by using following code:
SimpleDateFormat dateFormat = new SimpleDateFormat("YYYY-MM-dd");
Date lastCharged = dateFormat.parse(lastChargeDate);
Every time I run this code the date returned by…
mwaqas
- 3
- 2
-3
votes
1 answer
Different date time format of the user causing an error
My application is giving an error on different installation based on their different date/time format which my codes are based on
for example below original code ;
Private Sub DateTimePicker1_ValueChanged(sender As Object, e As EventArgs) Handles…
Ali
- 33
- 9
-4
votes
1 answer
Convert ISO time string to local time value
Hi everyone I am new to VBA I have some ISO times (i.e: 2020-06-12T23:44:00.000+0000) that I extracted from JSON and put into column 21 and started with row 2 going down to row 51. I am trying to use this…
user13880320