Subject Re: [firebird-support] Working with string, number and date formating
Author Dimitry Sibiryakov
On 20 Dec 2005 at 21:37, fkbash wrote:

>I must be able to get the data on the format below:
>- strings: formated with a specific amount of positions, if the string
>is shorter than the size need I must put blank spaces on the end of

CAST(field AS CHAR(NN)) will give you this.

>- date: formated following a parameter (dd/mm/yyyy, ddmmyyyy,
>yymmdd, etc);

CAST(field AS CHAR(8)) will give you YYYY-MM-DD.

> - number: formated with a specific amount of positions,
>if the number is shorter than the size needed I must put zeros on the
>begin of the number. The amount of digits in decimal must be a
>parameter and I need the number without decimal separator.

Sorry, this is not possible.

SY, Dimitry Sibiryakov.