nerotronics.blogg.se

TO_CHAR(tsltz_col, 'DD-MON-YYYY HH24:MI:SSxFF') AS tsltz SELECT TO_CHAR(ts_col, 'DD-MON-YYYY HH24:MI:SSxFF') AS ts_date, The result for a TIMESTAMP WITH LOCAL TIME ZONE column is sensitive to session time zone, whereas the results for the TIMESTAMP and TIMESTAMP WITH TIME ZONE columns are not sensitive to session time zone: The example shows the results of applying TO_CHAR to different TIMESTAMP data types. Tsltz_col TIMESTAMP WITH LOCAL TIME ZONE, The following example uses this table: CREATE TABLE date_tab ( If you omit 'nlsparam', then this function uses the default date language for your session.

The 'nlsparam' argument specifies the language in which month and day names and abbreviations are returned. Refer to " Format Models" for information on datetime formats. Interval values are converted to the numeric representation of the interval literal. TIMESTAMP WITH TIME ZONE values are converted to values in the default timestamp with time zone format. TIMESTAMP and TIMESTAMP WITH LOCAL TIME ZONE values are converted to values in the default timestamp format. If you omit fmt, then date is converted to a VARCHAR2 value as follows:ĭATE values are converted to values in the default date format. TO_CHAR (datetime) converts a datetime or interval value of DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE, INTERVAL DAY TO SECOND, or INTERVAL YEAR TO MONTH data type to a value of VARCHAR2 data type in the format specified by the date format fmt.