>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( '%04d%02d%02d%02d%02d%
| 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.
select * from yourtable where datefield < date_sub(now(),interval 3 day);
see mysql doc: http://www.mysql.com/doc/D/a/Date_and_time_functions.html
at
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
MySQL
906 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: mys
fax: 22 01 66 21
direkte: 22 01 66 34, 906 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
&
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:
>ht
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
