At 07:30 AM 17/09/2004 -0700, you wrote:

>Hi, what about date functions like GETDATE(),

CURRENT_DATE and CURRENT_TIMESTAMP

>DATEPARTT()

Read up on the EXTRACT() function

>;DATENAME()

There are UDFs for this style of function - it depends what you want.

>;DATEDIFF

To get a time interval in days, no function is required. Simply subtract
the earlier date (or timestamp) from the the later one.

Where can i get information about dates in firebird (i see the interbase
documentatrion sqlembeded.pdf)?

There is a section on Date and Time types in LangRef.pdf (another volume of
the InterBase 6 doc set).

Go here for links to user documentation:
http://firebird.sourceforge.net/index.php?op=doc&id=userdoc

./heLen