469,271 Members | 1,481 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,271 developers. It's quick & easy.

DbiDate object

Hi all

I am using odbc to connect to Microsoft Access DB. When I send a
request with a datetime column from the database, odbc returns
something called a DbiDate object.
ex :
>>x=data[0][2]
<DbiDate object at 0x009C4140>
>>print x
Fri Apr 20 07:27:45 2007

I would like to select columns where datetime ("DbiDate column") is >
yesterday date.
and i don't understand how to send request with this DbiDate.

Could you help me ?
thank you

May 28 '07 #1
2 1912
On May 29, 12:51 am, revuesbio <revues...@gmail.comwrote:
Hi all

I am using odbc to connect to Microsoft Access DB. When I send a
request with a datetime column from the database, odbc returns
something called a DbiDate object.
ex :>>x=data[0][2]

<DbiDate object at 0x009C4140>>>print x

Fri Apr 20 07:27:45 2007

I would like to select columns where datetime ("DbiDate column") is >
yesterday date.
and i don't understand how to send request with this DbiDate.

Could you help me ?
thank you
I also use the odbc module, but I store dates in my system as
datetime.datetime objects.

I convert a DbiDate object to a datetime object like this -

import datetime as dt
date = dt.datetime.fromtimestamp(int(dbidate))

For selects, I use the datetime object directly -

cur.execute('select * from table where date = ?',(date,))

I'm not sure how the odbc module handles that - maybe it converts date
into str(date). In any case, it just works for me.

HTH

Frank Millman

May 29 '07 #2
On 29 mai, 07:22, Frank Millman <f...@chagford.comwrote:
On May 29, 12:51 am, revuesbio <revues...@gmail.comwrote:
Hi all
I am using odbc to connect to Microsoft Access DB. When I send a
request with a datetime column from the database, odbc returns
something called a DbiDate object.
ex :>>x=data[0][2]
<DbiDate object at 0x009C4140>>>print x
Fri Apr 20 07:27:45 2007
I would like to select columns where datetime ("DbiDate column") is >
yesterday date.
and i don't understand how to send request with this DbiDate.
Could you help me ?
thank you

I also use the odbc module, but I store dates in my system as
datetime.datetime objects.

I convert a DbiDate object to a datetime object like this -

import datetime as dt
date = dt.datetime.fromtimestamp(int(dbidate))

For selects, I use the datetime object directly -

cur.execute('select * from table where date = ?',(date,))

I'm not sure how the odbc module handles that - maybe it converts date
into str(date). In any case, it just works for me.

HTH

Frank Millman
it works !
thank you for your help ;-)

May 29 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by lawrence | last post: by
1 post views Thread by Frank Millman | last post: by
1 post views Thread by Bijay Kumar | last post: by
reply views Thread by Bijay Kumar | last post: by
26 posts views Thread by yb | last post: by
7 posts views Thread by flupke | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.