And then there's the overall question -
What would be the least fiddly & least error prone way of working with dates and times? Python or SQL?
Liam, SQL is another language. You need to learn it like you are learning Python. It has pretty decent support for dates and times as part of the ANSI SQL spec.
There are defined types, SQL functions, etc.
week(date) = week(mydate) for instance.
I tend to prefer to write programming language agnostic databases because that way I can interact with them from any random language I need to. Sometimes things go bad and a quick little script which does:
rows = exec("select * from table")
exec("begin transaction")
for row in rows:
row[3] = row[2] + row[4] - 5 # we decided on a new value
exec("update fields in table")can be handy. _______________________________________________ Tutor maillist - [email protected] http://mail.python.org/mailman/listinfo/tutor
