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.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com