Python ADO Date Time database fields

Mike Driscoll kyosohma at gmail.com
Fri Jan 25 02:03:38 CET 2008


On Jan 24, 5:55 pm, goldtech <goldt... at worldpost.com> wrote:
> Hi,
>
> Given an MS-Access table with a date type field with a value of:
> 12:00:00 AM - just"12:00:00 AM", there's nothing else in the field.
>
> I want to print exactly what's in the field, ie. "12:00:00 AM". What I
> get printed is:   12/30/0/ 00:00:00
>
> I try:
>
> import win32com.client
> from win32.client import Dispatch
>
> oConn=Dispatch('ADODB.Connection')
> db = r'C:\mydb.mdb'
> oConn.Open("Provider=Microsoft.Jet.OLEDB.4.0; data Source="+db)
> oRS = Dispatch('ADODB.RecordSet')
> oRS.ActiveConnection =  oConn
> c = oConn.OpenSchema(20)
>
> while not c.EOF:
>     tn = c.Fields.Item('Table_Name').Value
>     oRS.Open(tn)
>     (oRS, dt) = oConn.Execute('SELECT date_field FROM '+tn+' GROUP BY
> date_field')
>     while not oRS.EOF:
>         print oRS.Fields(dt).Value  # print here
>          oRS.MoveNext()
>     c.MoveNext()
>
> oRS.Close()
> oConn.Close()
> # end
>
> What I get printed is:   12/30/0/ 00:00:00
>
> What do I to get exactly what's in the field?
>
> Thanks,
>
> Lee G

I don't know for sure, so I practiced my Google-Fu and found this
recipe which might be of use to you:

http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/52267

I also found this script, which might help you interface better with
Access:

http://www.ecp.cc/pyado.html

And then there just connecting to it with the adodb module:

http://phplens.com/lens/adodb/adodb-py-docs.htm

Mike



More information about the Python-list mailing list