I have a date comparison problem that I'm sure is simple enough but I'm just
not experienced enough to figure it out. I simply want to grab every entry
in a given table that has been entered within the last three days.
I'm using Perl so I first start with a Perl timestamp and convert it to a
I have a date comparison problem that I'm sure is simple enough but I'm just
not experienced enough to figure it out. I simply want to grab every entry
Um.
First of all, better code would be:
my @now = localtime( );
$now[5] += 1900;
$now[4] += 1;
$currenttime = sprintf(
Hello,
Is there a more general way to compare DATE values than the following.
...WHERE TO_DAYS(myDateField) TO_DAYS('2001-02-14');
I really have to objection to converting to a common unit of days in
order to compare (as long as I don't care about comparing times within
the same day), but I
Can you just not use...
...WHERE myDateField '1997-10-04 22:23:00'
...WHERE myDateField '1997-10-04'
?
regards,
P
You get the idea... thoughts?
Best,
Nick
-
Before posting, please check:
900 62
http://never.no - icq:103476059
~ hvis du ikke klarer det pa sorste forsok vil jeg ikke anbefale hangliding
~
-Opprinnelig melding-
Fra: Nick Didkovsky [mailto:[EMAIL PROTECTED]]
Sendt: 19. februar 2001 14:53
Til: mysql
Emne: Comparing dates
Hello,
Is there a more general
hangliding
~
-Opprinnelig melding-
Fra: Nick Didkovsky [mailto:[EMAIL PROTECTED]]
Sendt: 19. februar 2001 14:53
Til: mysql
Emne: Comparing dates
Hello,
Is there a more general way to compare DATE values than the following.
...WHERE TO_DAYS(myDateField) TO_DAYS