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 dates then the DATE type will suit your needs. You
just specify it
--- 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 dates then
hi
SELECT DATE_FORMAT(date_field ,%M %D %Y)
FROM table1
ORDER BY date_field
will order in true chronological order
Peter
-Original Message-
From: David Blomstrom [mailto:[EMAIL PROTECTED]
Sent: 22 June 2004 10:17
To: [EMAIL PROTECTED]
Subject: RE: New to Dates
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---
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
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
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
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
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
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
a
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 English Please
Jochem van Dieten wrote
11 matches
Mail list logo