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
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
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