OK,
Looks like there are two options
I can either convert the unix timestamp colomn to a mysql
time one *OR*
someone can tell me how to use unix timestamps in this query...
Try something like this:
SELECT
CONCAT(extract(year FROM FROM_UNIXTIME(time)),
extract(month FROM
Although my query returns the date of the day that had the highest number of
records inserted.
It outputs the total number of records in the table..
Can someone with more experience in SQL help me only count the number of
records inserted on the day with the highest number of records?
BTW the
$7c02a8c0;coconut...
Well, for one thing, EXTRACT() is for MySQL timestamps, not unix
timestamps.
---John Holmes...
-Original Message-
From: Noodle Snacks [mailto:webmaster;tececo.com]
Sent: Saturday, October 19, 2002 7:36 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] It counts