python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - datetime-parsing

Parsing Instant using OpenCsv

I am trying to parse Instant from a CSV using OpenCsv this way: @CsvDate("yyyy-MM-dd hh:mm:ss") @CsvBindByName(column = "date") private Instant date; I know that OpenCsv is suppos...
test-img

Tom Carmi

java

java-time

opencsv

datetime-parsing

java.time.instant

Votes: 0

Answers: 2

Latest Answer

See DateTimeFormatter. It should be HH for 24 hours time (0-23) i.o. hh for 12 hours time (1-12). The error is caused by hour "00". Fortunately, otherwise you would have only the first half ...
test-img

Joop Eggen

How to remove +00.00 from dictionary value c#

I have a Dictionary<string, object> collection. and the dictionary object looks {8/8/2021 1:38:34 PM +00:00} (datetime object) Facing some milliseconds problem because of +00:00. Need to remove ...
test-img

Gokul Kumar

c#

dictionary

datetime

datetimeoffset

datetime-parsing

Votes: 0

Answers: 1

Latest Answer

You can use LocalDateTime property of DateTimeOffset object to convert to DateTime. Assuming there is only DateTimeOffset in your dictionary you can do this Dictionary<string, object> di...
test-img

Thomas Barbare

Regex for hours, min and optionally Section with more possible formats

I need to create regex that allows below time values: single digit or double digits and optionally second. All possible combination for single digit of Hour/Minute/Second: hh:mm:ss AM/PM h:m:s AM/PM h...
test-img

dsi

regex

datetime-parsing

time-format

Votes: 0

Answers: 1

Latest Answer

The regex in the question doesn't make the am/pm optional. And the minutes/seconds can be 1 group that occurs 1 to 2 times. ^(?:[01]?[0-9]|2[0-3])(?:[:][0-5]?[0-9]){1,2}(?:[ ][APap][Mm])?$ Test on re...
test-img

LukStorms

Remove noise(hours) for parsing time in Y/M/D format

I am parsing the dates of my dataset, but am encountering a lot of ParserError because the hours are often in the wrong format. I've decided to skip the hours and only focus on Years, Months, Days The...
test-img

Mischa van ek

python

datetime

format

datetime-parsing

Votes: 0

Answers: 2

Latest Answer

I guess you can just dump the hour part dates = ['March 23, 2022 6:00', 'March 23, 2022 7:0', 'March 23, 2022 7:', 'March 23, 2022 7'] pd.to_datetime([' '.join(x.split(' ')[:-1]) for x in dates]) Dat...
test-img

Z Li

Posts

Questions

Blogs

Jobs