On Mon, 27 Oct 2003 19:11:53 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote:
For future reference, does this effect order by clauses in the way one
would expect? (ie., 00 precedes 01). The docs make it seem as though
use of invalid dates results in undefined behavior.
Can you indicate which part of
At 4:41 PM -0800 10/27/03, bluejack wrote:
On Mon, 27 Oct 2003 18:34:34 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote:
At 5:32 PM -0500 10/27/03, sean peters wrote:
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old data i have r
On Mon, 27 Oct 2003 18:34:34 -0600, Paul DuBois <[EMAIL PROTECTED]> wrote:
At 5:32 PM -0500 10/27/03, sean peters wrote:
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old data i have received only contains
the month and year, b
At 5:32 PM -0500 10/27/03, sean peters wrote:
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old data i have received only contains
the month and year, but not the date of the sale. Of course we want to store
this information, bu
On Mon, 27 Oct 2003 17:58:38 -0500, sean peters <[EMAIL PROTECTED]> wrote:
Well, thats actually what i am going to do. A date column won't take anything
but a valid date (sort of - feb. 30 is "valid").
But i still need to know whether the day of month is meaningful or not, for
various search / dis
On Mon, Oct 27, 2003 at 05:32:34PM -0500, sean peters wrote:
> Hi all,
> I have run into a date storage problem that i don't like. A am storing
> historic house sales, and some of the old data i have received only contains
> the month and year, but not the date of the sale. Of course we want to
:[EMAIL PROTECTED]
> Sent: Monday, October 27, 2003 4:33 PM
> To: [EMAIL PROTECTED]
> Subject: Unusual date storage requirement
>
>
> Hi all,
> I have run into a date storage problem that i don't like. A am storing
> historic house sales, and some of the old data i have rec
what about forcing the date to the first of whatever month the sale was in? if it's
got a valid date, put that, otherwise, put the first.
-Original Message-
From: sean peters [mailto:[EMAIL PROTECTED]
Sent: Monday, October 27, 2003 4:33 PM
To: [EMAIL PROTECTED]
Subject: Unusual
Hi all,
I have run into a date storage problem that i don't like. A am storing
historic house sales, and some of the old data i have received only contains
the month and year, but not the date of the sale. Of course we want to store
this information, but a DATE column won't quite do the job, be
