At 11:24 PM 16/10/2003 +0200, you wrote:

>Is there any possibility to format data type in different format like
>'YYYY/MM/DD' or 'MM/YYYY/DD'????
>
>If it is how to make it?

Read the Data Definition Guide. It contains tables showing all of the
valid date literal input formats. Forward-slash format is always
restricted to 'MM/DD/CCYY' or 'MM/DD/YY' but, otherwise, there is a lot of
flexibility.

heLen

>Max Wolfring wrote:
>
> > Yes. You can use CAST(variable AS type), some as the following:
> > CAST(CURRENT_DATE AS TIMESTAMP).
> >
> > Max
> > mwolfring@...
> >
> > -------Mensagem original-------
> >
> > De: firebird-support@yahoogroups.com
> > Data: quinta-feira, 16 de outubro de 2003 13:55:51
> > Para: firebird-support@yahoogroups.com
> > Assunto: [firebird-support] select and typecast data
> >
> > Helo!
> >
> > It is possible to typecast selected data???
> >
> > --
> > Ale¹ Curk :)
> >
> > + http://www.curk-sp.si
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> > .
> >
> > [Non-text portions of this message have been removed]
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> >
> <http://rd.yahoo.com/M=244522.3707890.4968055.1261774/D=egroupweb/S=1705115386:HM/A=1595056/R=0/SIG=124p07ne0/*http://ashnin.com/clk/muryutaitakenattogyo?YH=3707890&yhad=1595056>
>
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> > <http://docs.yahoo.com/info/terms/>.
>
>
>--
>Ales( Curk :)
>
>+ PETER CURK s.p. Rac(unalnis(ki inz(eniring
>+ Z(apuz(e 111, 5270 Ajdovs(c(ina
>+ 05/368 16 25, 041 646 035
>+ mailto:info@...
>+ http://www.curk-sp.si
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/