I'm afraid that's what system locale default settings are for
but you can override this with a select e.g.
f_dayofmonth(DATE_CREATED)||'.'||f_month(DATE_CREATED)||'.'||f_year(DATE_CRE
ATED) DATE_CREATED

Alan

> -----Original Message-----
> From: kimon_the_athenian2 [mailto:kimon_the_athenian2@...]
> Sent: Friday, 27 June 2003 5:12 PM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Date format
>
>
> Hello!
>
> Is there a way to specify what date format should firebird (1.5rc3)
> use when converting dates to strings; for example "date_field
> || 'some stuff'"? Something similar to oracle "alter session set
> nls_date_format = 'dd.mm.rrrr'" ? or firebird.conf option?
>
> Maybe there is some udf for it? Preferably it could also check
> (windows)system locale date format settings.
>
> Thank you!
>
> Aivar Annamaa
>
>
>
>
>
> 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/
>
>
>