View source for Python - DbiDate

=References=

* [http://www.python.org/doc/2.5/lib/module-datetime.html Python datetime module reference]

=Notes=

==Conversion==

Accessing a SqlServer dataabse via the ActiveState Python ODBC implementation returns dates as a DbiDate object.

To convert them into a datetime formate where they are more easily manipulated do the following:

<pre>
dt = datetime.datetime.fromtimestamp(int(dbidate))
</pre>

==DbiDate Use in SELECT==

For selects, use the datetime object directly -

<pre>
cur.execute('select * from table where date = ?',(dt,))
</pre>


[[Category:Python]]
[[Category:ODBC]]