Re: Help with extract and count

[Samantha Saldanha]

Hi
I suggest instead of using the extract operator why don't you

Go to your created table by typing
describe [table name];

Check for the variable in the date time format.
Suppose you have a variable say 'invoicedate' in the datetime field in your table.

select count(*) from [table name] where invoicedate >= "2010-08-17 00:00:00 " and invoicedate <= "2010-08-17 23:59:59";

This query will automatically count the number of transactions for the date 17 August. You can vary the time and date accordingly