laravel-oci8 icon indicating copy to clipboard operation
laravel-oci8 copied to clipboard

NLS_TIMESTAMP_TZ_FORMAT

Open T0miii opened this issue 7 years ago • 2 comments

Hi,

is there a config optio to set the NLS_TIMESTAMP_TZ_FORMAT ? I cant seem to find any info about it.

T0miii avatar Feb 08 '18 08:02 T0miii

You can use DB::setDateFormat('YYYY-MM-DD'). This command will set both date and timestamp format though. See https://yajrabox.com/docs/laravel-oci8/master/date-format.

yajra avatar Feb 16 '18 10:02 yajra

Oh, is NLS_TIMESTAMP_FORMAT equivalent to NLS_TIMESTAMP_TZ_FORMAT? If not, you will have to do a manual statement.

DB::statement("ALTER SESSION SET NLS_TIMESTAMP_TZ_FORMAT = 'YYYY-MM-DD'");

yajra avatar Feb 16 '18 10:02 yajra

This issue is stale because it has been open for 30 days with no activity.

github-actions[bot] avatar Nov 20 '22 03:11 github-actions[bot]

This issue was closed because it has been inactive for 7 days since being marked as stale.

github-actions[bot] avatar Nov 28 '22 02:11 github-actions[bot]