[2.5.1] Comparing dates?

[Ben Finney]

Gilles Ganault <nospam at nospam.com> writes:

> 	I have data in an SQL database where one column contains a
> date formated as DD/MM/YYYYY.
> 
> I need to select all rows where the date is before, say Feb 1st
> 2009, ie. 01/02/2009.

The Python data types for date and time are in the ‘datetime’ module
<URL:http://www.python.org/doc/2.6/library/datetime>. Create a
‘datetime’ object for each value you want, then compare them.

To create a ‘datetime’ value from a string, use ‘datetime.strptime’
(new in Python 2.5).

-- 
 \                            “Holy knit one purl two, Batman!” —Robin |
  `\                                                                   |
_o__)                                                                  |
Ben Finney