Dates and stuff

[jon_days]

Hi All, hope you can help.

I am trying to select a number of rows from a table, which have the timestamp for todays date.

the field is called ClickTime and it stores a timestamp of length 12, eg "040611183504" which is for 11 June 2004 at 18:35, however I need to select the rows with only the date 11 June 2004, can anyone let me know the correct MySQL command for that so I can then use it,

Thanks in advance.

Jon

[rachel2004]

MySQL's UNIX_TIMESTAMP should do the trick:

$begin_range = mktime(0, 0, 0, 6, 10, 2004);
$end_range = mktime(0, 0, 0, 6, 12, 2004);

$sql = "SELECT UNIX_TIMESTAMP(ClickTime)
        FROM table
        WHERE (UNIX_TIMESTAMP(ClickTime) > $begin_range)
        AND (UNIX_TIMESTAMP(ClickTime) < $end_range)";

Hope that helped.