[Tutor] date conversion
kent37 at tds.net
Wed Apr 5 19:50:06 CEST 2006
> On Wed, 2006-04-05 at 10:50 -0400, Kent Johnson wrote:
>> Ray Allen wrote:
>>> I would like Python to convert a date returned by MySQL (2006-04-05)
> Kent's advice below is of course correct, but I'd bet your variable is
> already a datetime.date (or mx.DateTime.Date with older Python
> releases). In that case you'd already be at step 7.
> When executing your update statement use the args field.
> cursor.execute("UPDATE table SET mydate=%s WHERE id=%s", (date_variable, recordID))
> You should not have to worry about getting your date into the proper
> string format for the database SQL syntax.
Good point. You may well be getting some kind of date object back from
MySQL, too, rather than a string.
More information about the Tutor