column localtimestamp format a28

    
SQL>
SQL> select localtimestamp from dual;
LOCALTIMESTAMP
---------------------------------------------------------------------------
16-JUN-08 01.26.59.426000 PM

1 row selected.

SQL>
SQL> select localtimestamp, current_timestamp
  2  from dual;
LOCALTIMESTAMP
---------------------------------------------------------------------------
CURRENT_TIMESTAMP
------------------------------------
16-JUN-08 01.26.59.496000 PM
16-JUN-08 01.26.59.496000 PM -11:00


1 row selected.

SQL>
SQL> alter session set time_zone = '-08:00';

Session altered.

SQL>
SQL> select localtimestamp, to_char(sysdate, 'DD-MON-YY HH:MI:SS AM') "SYSDATE"
  2  from dual;
LOCALTIMESTAMP                                                              SYSDATE
--------------------------------------------------------------------------- ---------------------
16-JUN-08 04.26.59.686000 PM                                                16-JUN-08 05:26:59 PM

1 row selected.

SQL>
SQL> --

1.	Use 'format a30 heading' to define column name
2.	Column format $9,999.99
3.	Column heading format a13
4.	Use a13 to set the column length during displaying
5.	Aligning decimals
6.	Adding a group separator
7.	Including a currency symbol
8.	Wrapping text
9.	JUSTIFY CENTER
10.	JUSTIFY RIGHT
11.	Disable the column formatting
12.	SET string to display when value is NULL
13.	COLUMN Salary heading "Current\|Salary" format $9999.99
14.	COLUMN fname heading "emp\|Name" format a10
15.	COLUMN id heading "emp\|Number" format 9999
16.	Copy column format with 'col ... like'
17.	column format: ascii type, 26 letter long
18.	column number format
19.	Column data is aligned by type
20.	Word Wrapped column format
21.	Set number column format
22.	Set column format before doing the query
23.	Set column heading with column command
24.	Set column separation with colsep

column localtimestamp format a28 : Column « SQL Plus « Oracle PL / SQL

Related examples in the same category