Hi Martijn,


--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> Hi,
>
> > how can i get the active date, time, timestamp format and
> > separator with sql ?
> >
> > i.e. dd/mm/yyyy or mm/dd/yyyy with separator '/'
> > or mm.dd.yyyy with separator '.' etc
>
> SELECT CURRENT_TIMESTAMP, CURRENT_TIME,
> CURRENT_DATE
>
> FROM RDB$DATABASE
>
> The separator is a client side display thingy.

Maybe i wasn't clear enough :)

I want to construct a sql query through code ( Delphi ). But
because the client's are in varius locales (Greek, English,
Bulgarian, Romanian ) different from the server locale i need a
universal way of constructing the date field or the time field or
the timestamp. Else i get an error message ... You
know '...transliterate blablabla ...'.

Thx,
--
Dimitrios Chr. Ioannidis