Tuesday, 22 December 2015

Remove Blanks from Formated Date Column

This small example is showing how powerful jQuery is and how easy it is to use it in APEX. In this case, I needed to correct the oracle formatting, which adds blanks to the name of the day prior to comma. Probably oracle RPAD's the day names to the longest (Wednesday). Those are showing in APEX as one blank - see the left column. The only good way to go around that annoying side effect is to use jquery and basically one line of code.


2 comments:

Jens said...

couldn't you just use the FM format?
http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements004.htm#SQLRF00216

e.g.
select to_char(sysdate, 'fmday, dd.mm.yyyy hh24:mi:ss') from dual;

Denes Kubicek said...

Sure, then you loose the sorting option.