Primoz,

this page from Ivan Prenosil might help too :

http://www.volny.cz/iprenosil/interbase/ip_ib_code_timestamp.htm


Regards.

--
Jerome

----- Original Message -----
From: "Planles" <planles@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, September 02, 2004 5:38 PM
Subject: RE: [firebird-support] Using period


> > Look at the EXTRACT functions...
> >
> > select * from table where extract(month from data_field) = 9
>
> Thanks Milan, that's what I was looking for.
>
> I found explanation of EXTRACT function in Helen's book on Page 157.
> Yesterday I came to Page 127. Have to read faster...
>
> Regards,
> Primoz
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>