: [EMAIL PROTECTED]
Subject: Re: [PHP] Output yyyymmdd formatted date || 20030131 to
FridayJanuary 31, 2003
Right.
I've switched the date column from type INT to type DATE in our MySql
db.
The problem I've had with retrieving records in a certain date range
with:
SELECT * FR
the real question here is are you storing your dates in a file or database.
If in a database (say MySQL), you can use the native DATE_FORMAT function of
MySQL to pull the date out in the proper format.
Otherwise, have a look at http://www.php.net/date
Quoting CF High [EMAIL PROTECTED]:
Sorry
PROTECTED]
Sent: Saturday, February 08, 2003 1:31 PM
Subject: Re: [PHP] Output mmdd formatted date || 20030131 to
FridayJanuary 31, 2003
the real question here is are you storing your dates in a file or
database.
If in a database (say MySQL), you can use the native DATE_FORMAT function
of
MySQL
The dates are stored in a MySql db.
I checked out the MySql DATE_FORMAT function -- pretty cool.
However, pardon my ignorance here, how can I do date comparisons?
For example, if I want to retrieve records from the db where the date
is
between say, 2003-02-01 and 2003-02-07, will MySql
' [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Saturday, February 08, 2003 3:31 PM
Subject: RE: [PHP] Output mmdd formatted date || 20030131 to
FridayJanuary 31, 2003
The dates are stored in a MySql db.
I checked out the MySql DATE_FORMAT function -- pretty cool.
However
]]
Sent: Saturday, February 08, 2003 10:20 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP] Output mmdd formatted date || 20030131 to
FridayJanuary 31, 2003
Right.
I've switched the date column from type INT to type DATE in our MySql
db.
The problem
6 matches
Mail list logo
