--- whoisquilty <[EMAIL PROTECTED]> wrote: > I'm trying to generate a table that gives some statistics. I've got a date > time column that > registers hits. I need to calculate the number of hits for 2006 using the > 'date' column, which > is the date time column. > > How do I access only the year?
MySQL has many useful date and time functions. It sounds like you want the year() function: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_year James
