Re: [python-win32] Python ADO and Date Time Field in Access

2008-01-30 Thread leegold
Thank for the stellar explanations and code. You plus the other posters and esp. the code examples make it clear what's going on. It's been very helpful. Thanks, Lee G. On Tue, 29 Jan 2008 10:39:25 +, Tim Golden [EMAIL PROTECTED] said: leegold wrote: ...snip... I was coming from

Re: [python-win32] Python ADO and Date Time Field in Access

2008-01-29 Thread Tim Golden
leegold wrote: ...snip... I was coming from the equivalent Perl code and now trying it in Python. [... snip code examples ...] Well, seeing you've gone to the trouble of posting the code... even if you didn't provide a working database for those of use without access to Access (pun

Re: [python-win32] Python ADO and Date Time Field in Access

2008-01-28 Thread Tim Roberts
leegold wrote: Hi, Given an MS-Access table with a date type field with a value of: 12:00:00 AM - just12: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. Do you understand that this is not really what's present in that field?

Re: [python-win32] Python ADO and Date Time Field in Access

2008-01-28 Thread leegold
...snip... I want to print exactly what's in the field, ie. 12:00:00 AM. Do you understand that this is not really what's present in that field? What's present in the field is a floating point number. The number happens to represent the number of days since December 30, 1899. Hours,