try:

select extract(month from current_date) from rdb$database

HTH,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging Tool for Interbase/Firebird
http://www.iblogmanager.com

> -----Original Message-----
> From: maria_ana_ph [mailto:maria_ana_ph@...]
> Sent: Wednesday, April 03, 2002 7:17 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] MONTH
>
>
> How can i access today's month?
> Are there any available date literals?
>
> regards,
> Maan 8)
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>