PyTime Object and Application Crashing

[Ryan Scott]

Hi,

When I run a query against an access database and the default date for
my date/time field is 12/30/1899 the application crashes. Changing this
to a different date like 03/03/2003 works.
The output of the query when returned as a list is as follows:

[571, u'DE8', <PyTime:10/2/2003 12:00:00 AM>, <PyTime:12/30/1899 1:05:51
PM>, 0.
079999998211860 657, u'1 - Litter in sample', u'', False, 10.0, 0.0]

When I try to print item 4 (list[3]) of the list, the application stops
and I get a "Send Error Report" in Windows XP.

I am using python 2.3.3 and the win32all-163 extension.

Thanks
Ryan

[Dennis Lee Bieber]

Re: PyTime Object and Application Crashing

On Tue, 20 Jan 2004 21:54:02 -0500, Ryan Scott <ryan.scott@sym patico.ca>
declaimed the following in comp.lang.pytho n:
[color=blue]
> Hi,
>
> When I run a query against an access database and the default date for
> my date/time field is 12/30/1899 the application crashes. Changing this[/color]

From the Access help file:
access>
access> DATE
access> Returns the serial number of a particular date.
access>
access> Syntax
access>
access> DATE(year,month ,day)
access>
access> Year is a number from 1900 to 9999.
access>
access> Month is a number from 1 to 12 that represents the month of
the year.
access>
access> Day is a number from 1 to 31 that represents the day of the
month.

Take a close look at the valid range for Year.

--[color=blue]
> =============== =============== =============== =============== == <
> wlfraed@ix.netc om.com | Wulfraed Dennis Lee Bieber KD6MOG <
> wulfraed@dm.net | Bestiaria Support Staff <
> =============== =============== =============== =============== == <
> Home Page: <http://www.dm.net/~wulfraed/> <
> Overflow Page: <http://wlfraed.home.ne tcom.com/> <[/color]