Hi,

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

No, no and no.

Firebird already accepts multiple format - but I always use
mm/dd/yyyy and convert at the client side, or use a parameterized
query, avoiding the conversion.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com