Yes - it may work like you are saying, but I would use a timestamp to be sure.
You can make comparisons on regular date formats from within MySQL with the
date or datetime fields.
--Joe
On Mon, Jan 15, 2001 at 12:39:13PM -0600, Jacky@lilst wrote:
> all right, now I have both date values in the same format (yyyy/mm/dd), say
> $Date1 = 20010115 and $Date2 =20010120. If what I want is to find out if
> $Date1 come before $Date2, can I just use this sniplet below?
>
> if ($Date1 < $Date2) {
> ...........
> } else {
> .......
> }
>
> Do I still need to use mktime() for this purpose?
> cheers
> Jack
> [EMAIL PROTECTED]
> "There is nothing more rewarding than reaching the goal you set for
> yourself"
> ----- Original Message -----
> From: Jason Murray <[EMAIL PROTECTED]>
> To: 'Jacky@lilst' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Sunday, January 14, 2001 11:37 PM
> Subject: RE: [PHP] date comparison
>
>
> > > can I used the value from that variables to compare with another
> > > date value? Say another date value I will use is also retrieved
> > > from a field in table which is in Date data type as well.
> >
> > When you get into this stuff, it all starts getting a lot more
> complicated.
> >
> > If you want to compare two fields, make sure they're in the same format.
> >
> > Basically, make sure you use four digit years and two digit months and
> > days to create your birthday fields, so they look like (for example, with
> > today's date, 20010115 instead of 2001115 - that second one could really
> > be anything).
> >
> > If you're sure you're storing the birthdays properly, you can then cut
> > the strings up when you pull them out of the database, the first 4 chars
> > are the year, the next two make the month (regardless of the actual month,
> > this way it'll be "01" not "1"), then the day.
> >
> > Do that for both of the dates.
> >
> > Now, you can use the mktime() command to turn them into unix tiumestamps.
> >
> > $unixtimeme = mktime(myhour, myminute, mysecond, mymonth, myday,
> myyear);
> > $unixtimethem = mktime(theirhour, theirminute, theirsecond, theirmonth,
> > theirday, theiryear);
> >
> > Now, a unix timestamp is the number of seconds from 00:00:01, Jan 1, 1970.
> >
> > You can figure out the difference in seconds between the two timestamps.
> >
> > Divide it by (24*3600), which is the number of seconds in a day, and there
> > you have the number of days between the dates.
> >
> > Incidentally, if you want to find the number of days between your
> birthDAYS,
> > then you'll want to substitute in a specific year in the mktime()
> statements
> > above, as you'll otherwise end up with the number of days between your
> exact
> > DATES of birth.
> >
> > Jason
> >
> > --
> > Jason Murray
> > [EMAIL PROTECTED]
> > Web Design Team, Melbourne IT
> > Fetch the comfy chair!
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
Joe Stump, PHP Hacker
[EMAIL PROTECTED]
http://www.miester.org/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
