Re: [Tutor] Dates and databases, and blobs and Python.

2005-03-26 Thread Liam Clarke
Hi Kent, > Most databases have a DATE type and you can directly store and retrieve date > objects. Looking at the > pysqlite code I see it uses mxDateTime for date support - it doesn't use the > Python datetime module. > > So the first step is to install mxDateTime from > http://www.egenix.c

Re: [Tutor] Dates and databases, and blobs and Python.

2005-03-26 Thread Sean Perry
Liam Clarke wrote: 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 p

[Tutor] Dates and databases, and blobs and Python.

2005-03-26 Thread Liam Clarke
Hi, Just a quick query. I want to store dates and work with them in my SQLite database. There's no specific need for any calculations to done on one side or another (i.e. it's a single user database). I googled how to work with dates in SQL, and I got one like this - SELECT * FROM totp WHERE w