Hi Usha

The formating of data is usually done on the client side. However,
if you insist on doing the formatting from within your query, you will
have to use a user defined function that will take a date as your
input and returns a string which represents the format you seek.

Basically, the function you are looking for is similar to the
FormatDateTime('dd-mmm-yyyy', aDate). I am not sure if it
already exists in the UDF that comes with IB.
Just in case, I have the sources for the UDF.
They can be compiled using Delphi. In the event
the function you are looking for does not exist, let me know.

Salim


From: Usharani
...
I need to know how to format the date as the following by using the sql
query. is there any functions to format the date as the following.

12-dec-2001
...