Re: time() searching

Well, best (most flexible) is to keep your database with a real database native time format, but if you've got things in time() format (by which I think you mean "unix epoch time"), just convert the date you want to search for into that same format and search for it. You can use Time::Local:

my $startdate = timelocal(0,0,0,1,0,2002-1900); # Jan 1
my $enddate = timelocal(0,0,0,2,0,2002-1900);   # Jan 2
[download]

then search for dates between those.

Curt

Comment on Re: time() searching Download Code

Replies are listed 'Best First'.
Re: Re: time() searching by husker (Chaplain) on Jun 23, 2003 at 13:41 UTC
Agreed. If you keep a "readable" date/time stamp in the database, then you pay the penalty to convert from time() to a real date/time stamp once ... when you create or update the record. If you have the time() format in your database, then you likely have to pay the price to convert it to readable date/time every time you access the record.	[reply]