How to convert 10 digit mysql date to django date format

[laspal]

Hi,

How to convert mysql 10 digit date format to django date format?
example:
mysql date - 1219848914
to django date - "22-05-09"


thanks.

[googletorp]

Hi
It looks like a unix timestamp. I cant remember what python uses to
convert unix to a date objecr but should be pretty simple. Maybe
strftime/strptime or you can just google it.

~Jakob

[R. Gorman]

As the previous post mentioned, I'm assuming that is a unix timestamp.
The module you want to use is datetime.

import datetime
mysql_date = datetime.datetime.fromtimestamp(1219848914)

mysql_date can be save directly to a datetime model field. However, if
you are wanting the date formatted as you provided, the last step
would be:

mysql_date.strftime("%d-%m-%y")

R.