""Salim Naufal"" <salim.naufal@...> wrote in message
news:000901c184a4$913754b0$3401a8c0@moushou...

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

It can be done in a selectable stored procedure, using the concatenation
operator, a couple of IF's and the EXTRACT built-in function.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing