partial date and a complete date.
Cheers
Andrew.
- Original Message -
From: "Michael Stassen" <[EMAIL PROTECTED]>
To: "Jochem van Dieten" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 22, 2004 8:30 PM
Subject: Re: New to Dates - Plain
Jochem van Dieten wrote:
Michael Stassen wrote:
Jochem van Dieten wrote:
David Blomstrom wrote:
Suppose you have a list of dates in the proper format,
like this:
2004-02-04
2003-11-02
and you encounter a date with only the month and year,
like May 2002. How would you insert that
Not. Prompt the us
Michael Stassen wrote:
Jochem van Dieten wrote:
David Blomstrom wrote:
Suppose you have a list of dates in the proper format,
like this:
2004-02-04
2003-11-02
and you encounter a date with only the month and year,
like May 2002. How would you insert that
Not. Prompt the user for a full date.
That i
At 9:03 -0700 6/22/04, David Blomstrom wrote:
One more question...
Suppose you have a list of dates in the proper format,
like this:
2004-02-04
2003-11-02
and you encounter a date with only the month and year,
like May 2002. How would you insert that, something
like this?:
2004-02-04
2003-11-02
200
At 23:40 -0700 6/21/04, David Blomstrom wrote:
I haven't worked with dates yet and wondered if
someone could give me an overview in plain English.
At the moment, I'm working on a table with a column of
dates in this format:
March 2, 2003
July 7, 2004
If I understand the Manual, the correct format
Jochem van Dieten wrote:
David Blomstrom wrote:
Suppose you have a list of dates in the proper format,
like this:
2004-02-04
2003-11-02
and you encounter a date with only the month and year,
like May 2002. How would you insert that
Not. Prompt the user for a full date.
Jochem
That is not strictly
David Blomstrom wrote:
Suppose you have a list of dates in the proper format,
like this:
2004-02-04
2003-11-02
and you encounter a date with only the month and year,
like May 2002. How would you insert that
Not. Prompt the user for a full date.
Jochem
--
MySQL General Mailing List
For list archives
One more question...
Suppose you have a list of dates in the proper format,
like this:
2004-02-04
2003-11-02
and you encounter a date with only the month and year,
like May 2002. How would you insert that, something
like this?:
2004-02-04
2003-11-02
2002-05---
__
> Subject: RE: New to Dates - Plain English Please
>
>
> --- Peter Lovatt <[EMAIL PROTECTED]> wrote:
> > Hi
> >
> > There are two aspects to dates, and your questions
> > include parts of both.
> >
> > When MySql stores dates you have a choice
--- Peter Lovatt <[EMAIL PROTECTED]> wrote:
> Hi
>
> There are two aspects to dates, and your questions
> include parts of both.
>
> When MySql stores dates you have a choice of column
> types
>
> http://dev.mysql.com/doc/mysql/en/DATETIME.html
>
> has the details
>
> If you just need to store
f "2004-02-12"
Hope this clarifies it..
Come back to me if not
Peter
> -Original Message-
> From: David Blomstrom [mailto:[EMAIL PROTECTED]
> Sent: 22 June 2004 07:40
> To: [EMAIL PROTECTED]
> Subject: New to Dates - Plain English Please
>
>
>
I haven't worked with dates yet and wondered if
someone could give me an overview in plain English.
At the moment, I'm working on a table with a column of
dates in this format:
March 2, 2003
July 7, 2004
If I understand the Manual, the correct format for
these dates in a MySQL table would be li
12 matches
Mail list logo