How can I reduce the width of column in Oracle (SQL Plus) with TIMESTAMP datatype? -

-

in sql plus output taking more space needs , i'd reduce 50 chars 20.

if reduce width 20 won't wide enough default timestamp or timestamp time zone format. when happens, sqlplus wrap value.

assume table b has timestamp column ts:

column ts format a20 select ts b;  ts -------------------- 25-apr-13 11.28.40.1 50000

to cut down width further, decide information want , format accordingly. oracle datetime , timestamp formatting codes listed here.

note sqlplus won't let specify date format column statement. that's why used format a20 above. can 19 characters if drop fractional seconds , use 24-hour clock instead of am/pm, , drop time zone:

column tsformatted format a20 select to_char(ts, 'mm/dd/yyyy hh24:mi:ss') tsformatted b;  tsformatted -------------------- 04/25/2013 11:28:40

if you're willing drop century can 2 of fractional seconds , exact width of 20:

column tsformatted format a20 select to_char(ts, 'mm/dd/yy hh24:mi:ss.ff2') tsformatted b;  tsformatted -------------------- 04/25/13 11:28:40.15

finally, if want of timestamps automatically formatted in way, use alter session:

alter session set nls_timestamp_format = 'mm/dd/yy hh24:mi:ss.ff2'; column ts format a20 select ts b; -- don't need to_char because of default format  ts -------------------- 04/25/13 11:28:40.15

Popular posts from this blog

Php - Delimiter must not be alphanumeric or backslash -

-
this question has answer here: delimiter must not alphanumeric or backslash , preg_match 5 answers this question has been asked don't know how fix problem in situation. getting following php errror: php message: php warning: preg_match(): delimiter must not alphanumeric or backslash in... on line 227 line 227 following: if (preg_match($match, $_server['http_user_agent'])) and function: $oslist = array ( 'windows 3.11' => 'win16', 'windows 95' => '(windows 95)|(win95)|(windows_95)', 'windows 98' => '(windows 98)|(win98)', 'windows 2000' => '(windows nt 5.0)|(windows 2000)', 'windows xp' => '(windows nt 5.1)|(windows xp)', 'windows server 2003' => '(windows nt 5.2)', 'windows vista' => '(windows nt 6.0)', 'w...
Read more

Delphi interface implements -

-
i expect reference counting should work on outer aggregating object in interface implementation. if can refer example: clarity in classes implementing multiple interfaces (alternative delegation): here minimal reproduction of behaviour: program so16210993; {$apptype console} type ifoo = interface procedure foo; end; tfooimpl = class(tinterfacedobject, ifoo) procedure foo; end; tcontainer = class(tinterfacedobject, ifoo) private ffoo: ifoo; public constructor create; destructor destroy; override; property foo: ifoo read ffoo implements ifoo; end; procedure tfooimpl.foo; begin writeln('tfooimpl.foo called'); end; constructor tcontainer.create; begin inherited; ffoo := tfooimpl.create; end; destructor tcontainer.destroy; begin writeln('tcontainer.destroy called');//this line never runs inherited; end; procedure main; var foo : ifoo; begin foo := tcontainer.create; foo.foo; end; begin main; readln...
Read more

css - Jqgrid: Multiselect in toolbar filter -

-
i want add multiple select toolbar filter, since not supported natively jqrid. best , easiest reuse ui.multiselect plugin comes together, however, im not able succeed that. my idea render comes searchoptions (i did simplified example make more clear): searchoptions:{multiple:true, value:'true:true;false:false', defaultvalue:'false'} and run multiselect rendering on given column: $("#gs_example").multiselect() but instead of expected dropdownbox got ugly picture: http://i38.tinypic.com/2zgvuh3.jpg i cannnot bring mutliselect frame foreground or whatsoever... <div class="ui-multiselect ui-helper-clearfix ui-widget" style="width: 146px;"> <div class="selected"> <div class="actions ui-widget-header ui-helper-clearfix"> <span class="count">1 items selected</span> <a class="remove-all" href="#">remove all</a> </div> <ul class=...
Read more