You don't have to worry about how you store the date. Leave the sorting up to the DB when you retrieve the data that you need. What is the 'time' column in the searches table, an Integer, a DATETIME, TIME, DATE? If its a a DATETIME field then this should do the trick 
my $query = qw/INSERT INTO searches (search, engine, time) values (?,?
+,NOW())/;
$sth = $dbh->prepare($query);
$sth->execute($search, $engine);

[download]
To retrieve these: 
my $sth = $dbh->prepare (<<EOSQL);
SELECT search, engine, DATE_FORMAT(time, "%W the %D of %M, at %r") as 
+formatted_date from searches
EOSQL
$sth->execute;

[download]
This will return formatted_date as "Thursday the 10th of August, at 16:45 PM" You should probably check out the date/time functions page on the MySQL web site.

In reply to Re: sorting mysql by week and year by gcalexander
in thread sorting mysql by week and year by Anonymous Monk

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.