Difference between revisions of "Python - DbiDate"
Jump to navigation
Jump to search
PeterHarding (talk | contribs) (New page: =References= * =Notes= Accessing a SqlServer dataabse via the ActiveState Python ODBC implementation returns dates as a DbiDate object. To convert them into a datetime formate where t...) |
PeterHarding (talk | contribs) |
||
| Line 4: | Line 4: | ||
=Notes= | =Notes= | ||
==Conversion== | |||
Accessing a SqlServer dataabse via the ActiveState Python ODBC implementation returns dates as a DbiDate object. | Accessing a SqlServer dataabse via the ActiveState Python ODBC implementation returns dates as a DbiDate object. | ||
| Line 12: | Line 14: | ||
dt = datetime.datetime.fromtimestamp(int(dbidate)) | dt = datetime.datetime.fromtimestamp(int(dbidate)) | ||
</pre> | </pre> | ||
==DbiDate Use in SELECT== | |||
For selects, use the datetime object directly - | |||
<pre> | |||
cur.execute('select * from table where date = ?',(date,)) | |||
</pre> | |||
[[Category:Python]] | [[Category:Python]] | ||
[[Category:ODBC]] | [[Category:ODBC]] | ||
Revision as of 13:38, 28 May 2008
References
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:
dt = datetime.datetime.fromtimestamp(int(dbidate))
DbiDate Use in SELECT
For selects, use the datetime object directly -
cur.execute('select * from table where date = ?',(date,))