LMPX.COM |
Home | Linux | Mysql | PHP | XML | ||
|
|
|||
From: J Alejandro Ceballos Z Date: Sun Jan 20 20:32:45 2008 Subject: Looping Dates.
El 19/01/2008, a las 12:39 a.m., beginners-cgi-digest-help@perl.org escribió: > > beginners-cgi Digest 19 Jan 2008 06:39:46 -0000 Issue 989 > > Topics (messages 13145 through 13145): > > Looping Dates. > 13145 by: sara.samsara.gmail.com > > Administrivia: > > To subscribe to the digest, e-mail: > <beginners-cgi-digest-subscribe@perl.org> > > To unsubscribe from the digest, e-mail: > <beginners-cgi-digest-unsubscribe@perl.org> > > To post to the list, e-mail: > <beginners-cgi@perl.org> > > > ---------------------------------------------------------------------- > > De: <sara.samsara@gmail.com> > Fecha: 19 de enero de 2008 12:39:34 a.m. GMT-06:00 > Para: <beginners-cgi@perl.org> > Asunto: Looping Dates. > > > I am stuck here, I want to get list of dates in a certain range. > Like: Start Date: 2007-01-03 to End Date: 2007-05-30 > > I am pointless here as what should I do in order to get all dates > between start and end? Is there any for, foreach loop or other > method? that will generate a list of dates: > Do you mean to retrieve? like SELECT something FROM tbl_name WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col or to populate? like INSERT dates INTO tbl_name (NOW()); ? maybe with some Date function via mysql http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html J. Alejandro Ceballos Z.
| Navigate in group perl.beginners.cgi at sever nntp.perl.org | |
| Previous | Next |
| © No Copyright You are free to use Anything |
Site Maintained by PHP Developer
Powered By PHP Consultants |