Subject Re: [ib-support] Hai
Author Claudio Valderrama C.
""Salim Naufal"" <salim.naufal@...> wrote in message
> 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.

Claudio Valderrama C. - -
Independent developer
Owner of the Interbase® WebRing