--- In firebird-support@yahoogroups.com, "Raigo" <raigo77@s...> wrote:

> thanks, I got this to work.
>
> but I have one more question, about CAST'ing strings back to date. Is
> there something like Delphi has EncodeDate in Firebird?
>
> In my machine date format is dd.mm.yyyy, and putting them together in
> that order works, but date format can be anything else, then joining
> just strings with dots can cause problems?

Raigo, _inside_ FB, in SP/triggers, locale settings of operation
system means nothing, FB use own pre-defined formats for string-date
casting. Among them are dd.mm.yyyy, mm/dd/yyyy and several others.
Note delimeters usage is hardly related to format.

Best regards,
Alexander.