| Subject | Re: Iterating through the first day of a month between two dates |
|---|---|
| Author | jrodenhi |
| Post date | 2009-01-02T18:46:42Z |
Is this what you are looking for?
SELECT DATEADD(month,1,DATEADD(day,
1-EXTRACT(DAY FROM CAST('01/15/2009' AS DATE)),
CAST('01/15/2009' AS DATE)))
FROM RDB$DATABASE
Of course, you have to supply your own value for the date literal.
Jack
[Non-text portions of this message have been removed]
SELECT DATEADD(month,1,DATEADD(day,
1-EXTRACT(DAY FROM CAST('01/15/2009' AS DATE)),
CAST('01/15/2009' AS DATE)))
FROM RDB$DATABASE
Of course, you have to supply your own value for the date literal.
Jack
[Non-text portions of this message have been removed]