Have a look on the EXTRACT keyword.

For example.

select EXTRACT(year from current_timestamp) from rdb$database
select EXTRACT(month from current_timestamp) from rdb$database
select EXTRACT(day from current_timestamp) from rdb$database
select EXTRACT(hour from current_timestamp) from rdb$database
select EXTRACT(minute from current_timestamp) from rdb$database
select EXTRACT(second from current_timestamp) from rdb$database

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

> -----Original Message-----
> From: Richard Pendered [mailto:rpendered@...]
> Sent: Thursday, May 23, 2002 1:44 PM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Date Time routines
>
>
> Hi,
> I know the info is posted somewhere, but I can't seem to find it.
> How do I extract the year, month, day, hour, minute and second from a
> timestamp field in dialect 3 ?
> TIA
> Rich P...
>
>
> [Non-text portions of this message have been removed]
>
>
>
> 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/
>
>
>
>