Subject | session variable to control timestamp/date format |
---|---|
Author | Rafael Kitover |
Post date | 2010-02-06T22:21:09Z |
Hello,
in Oracle it's possible to do something like:
alter session set nls_date_format = ' ... '
alter session set nls_timestamp_format = ' ... '
to set the way dates are displayed as a string for the current session.
Is there something similar for Firebird? I know I can use functions to
format dates, and will do that if there is no other way, but I was
hoping there is a session variable (or 'temporary option' like in
SQLAnywhere) to do this.
in Oracle it's possible to do something like:
alter session set nls_date_format = ' ... '
alter session set nls_timestamp_format = ' ... '
to set the way dates are displayed as a string for the current session.
Is there something similar for Firebird? I know I can use functions to
format dates, and will do that if there is no other way, but I was
hoping there is a session variable (or 'temporary option' like in
SQLAnywhere) to do this.