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 com
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 entir
...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. Hou
leegold 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".
Do you understand that this is not really what's present in that field
leegold 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.
>
As you note later nothing "visible" If you run the following query:
SELECT Year([field1]) AS Expr1, Month([field1]) AS Expr2, Day([fie
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 imp
