Subject Re: [ib-support] Date Time routines
Author Martijn Tonies

> 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 ?
> Rich P...

EXTRACT(MONTH FROM timestampcolumn)


Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."