Hey Michael. 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 be able to compare the strings? I stored my dates as integer fields to do such a comparison, but it looks like I need to graduate to MySql date time functions.......... --Noah ----- Original Message ----- From: "Michael Geier" <[EMAIL PROTECTED]> To: "CF High" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, February 08, 2003 1:31 PM Subject: Re: [PHP] Output yyyymmdd 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 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 for the frequent simple posts........... > > > > I've been storing my dates in yyyymmdd format (apparently this is a bad > > idea). > > > > In any case, I need to display this date format as [day name month name day > > #, year] e.g. Friday January 31, 2003. > > > > Any ideas? > > > > Thanks for any leads, > > > > --Noah > > > > -- > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > ======================================= > Michael Geier > CDM Sports, Inc. Systems Administration > email: [EMAIL PROTECTED] > phone: 314.692.3540 > > ----------------------------------------------- > This email sent using CDM Sports Webmail v3.1 > [ http://webmail.cdmsports.com ] > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
