| Subject | Re: [firebird-support] Number od days in selected month |
|---|---|
| Author | Ivan Prenosil |
| Post date | 2006-08-07T10:55:48Z |
> How to get a number of days into SELECTED SQL statement from datehttp://www.volny.cz/iprenosil/interbase/ip_ib_code_timestamp.htm#_code3_monthlength
> field, for example:
> SELECT Date, xxx AS Days
> FROM Table1
> WHERE Date = '13.08.2006'
>
> Result:
> Date Days
> ====================
> 13.08.2006 31
Ivan