Document Type | Technical Information
Category | Administration
Applicable Product Version | 6FS07, 7FS02
Document Number | TADTI001
Overview
This guides you on how to change the result format after querying a Date Type column in Tibero Studio 2.
Method
Scenario (Performed in Tibero Studio 2)
alter session set nls_date_format='yyyymmdd hh24:mi:ss'; select startup_time from gv$instance; <Result> Startup_time 2025/03/07
Note
Even if you change the date format with the Alter Session statement, only โYear/Month/Dayโ is displayed.
1. Execute alter session set nls_date_format='yyyymmdd hh24:mi:ss'
alter session set nls_date_format='yyyymmdd hh24:mi:ss';
2. Change NLS Data Format Settings
- In Tibero Studio 2 menu bar โ windows โ Preferences โ Data Format โ Uncheck Skip NLS Settings by clicking the checkbox โ Apply NLS Data Format as YYYY/MM/DD HH24:MI:SS
3. Confirm Application
Startup_time 2025/03/07 12:35:09