Hi, ALL, I'm working on the python script which reads the data from the csv file. In this file I have 3 different kind of fields: one consist of the sole date, one - sole time and one - datetime. The time includes milliseconds, i.e. "12:55:55.705" All fields of the file including those 3 I am reading as the string. All those strings after validating will go into mySQL table.
Now, it looks that the python way of validating the date/time of the string is to call strptime(). However looking at the docs and trying to use the function I didn't find a way to check for the milliseconds. Now the dates can be formatted differently I think according to the locale under which the csv is generated. So, my question is: since there is a simple way of inserting preformatted string into the datetime field of mySQL, how do I validate the date string? I don't want to convert that string to datetime object, just want to check if all those types of dates are good dates and does not contain garbage. I tried to do an RE, but its static validation and so will not work in all cases. Thank you for any hints. -- https://mail.python.org/mailman/listinfo/python-list
