Re: Python ADO Date Time database fields

2008-01-25 Thread John Machin
On Jan 26, 12:48 am, goldtech <[EMAIL PROTECTED]> wrote: > snip > > > > > try this: > > > val = oRS.Fields(dt).Value > > print type(val) > > this gives: > > > print float(val) > > yes, it gives 0.0 > > But there should be a way to print what is *actually in the field*. What is "actually in the f

Re: Python ADO Date Time database fields

2008-01-25 Thread Mike Driscoll
On Jan 25, 7:48 am, goldtech <[EMAIL PROTECTED]> wrote: > snip > > > > > try this: > > > val = oRS.Fields(dt).Value > > print type(val) > > this gives: > > > print float(val) > > yes, it gives 0.0 > > But there should be a way to print what is *actually in the field*. > When I open the DB table i

Re: Python ADO Date Time database fields

2008-01-25 Thread goldtech
snip > > try this: > > val = oRS.Fields(dt).Value > print type(val) this gives: > print float(val) yes, it gives 0.0 But there should be a way to print what is *actually in the field*. When I open the DB table in Access I see: 12:00:00 AM. That's what I want - the value, and the form of th

Re: Python ADO Date Time database fields

2008-01-25 Thread John Machin
On Jan 25, 10:55 am, goldtech <[EMAIL PROTECTED]> 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

Re: Python ADO Date Time database fields

2008-01-24 Thread Mike Driscoll
On Jan 24, 5:55 pm, goldtech <[EMAIL PROTECTED]> 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/