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...

EXTRACT(MONTH FROM timestampcolumn)

etc.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

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