in reply to Database time or just time
It sounds like you are calling localtime() in a list context and just storing the first value returned (the seconds) into the database.
Without seeing your code, I'd suggest using ''.localtime() so that you are sure to get the string version of the return value.
Update: Um, I don't do much with dates in databases these days, but I think you'll need to format the date so that your database will recognize it. Extracting the fields as Maclir suggests and then using sprintf is probably a better idea. Don't forget to add 1900 to the year and 1 to the month, though!
- tye (but my friends call me "Tye")
|
|---|