Subject | Question on Month date range in SELECT statements |
---|---|
Author | myles@techsol.org |
Post date | 2006-10-19T17:29:43Z |
This is probably an elementary question, but if I have a table of rows
(millions) and they all have a TIMESTAMP column in them, and I want to get a
total count of the number of rows that are in the table for the current
month, are there any built in commands to do this in Firebird 1.5, or do I
have to write a stored procedure that will take into consideration the date
ranges of each month of the year to determine if a row is a candidate for
the current month?
Thanks in advance for any advice.
Myles
============================
Myles Wakeham
Director of Engineering
Tech Solutions US, Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
www.techsol.org
(millions) and they all have a TIMESTAMP column in them, and I want to get a
total count of the number of rows that are in the table for the current
month, are there any built in commands to do this in Firebird 1.5, or do I
have to write a stored procedure that will take into consideration the date
ranges of each month of the year to determine if a row is a candidate for
the current month?
Thanks in advance for any advice.
Myles
============================
Myles Wakeham
Director of Engineering
Tech Solutions US, Inc.
Scottsdale, Arizona USA
Phone (480) 451-7440
www.techsol.org