How do I find threads created in certain time period?

[seaweed]

Im trying to find All threads created in a certain month, Can this product do this?
If so how?
tia
seaweed

[tonjohn]

Yes.

You can run your own query like:

SELECT t.*
FROM thread t
WHERE t.dateline >= unix_timestamp(START_OF_MONTH) AND t.dateline < unix_timestamp(END_OF_MONTH)

[Eslob]

tonjohn,

this query posted in cp?

or in phpmyadmin?

[tonjohn]

You can either go to the admincp -> maintenance ->execute sql query OR you can do it in phpmyadmin.

Here is the actual query to select all threads created in January 2012:

SELECT t.*
FROM thread t
WHERE t.dateline >= unix_timestamp('2012-01-01') AND t.dateline < unix_timestamp('2012-02-01')