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.


on

3 comments:

  1. Jens22 December 2015 at 10:52

    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;

    ReplyDelete
  2. Denes Kubicek22 December 2015 at 11:49

    Sure, then you loose the sorting option.

    ReplyDelete
  3. Replacement Windows Riverview28 July 2022 at 19:13

    This is a great post thanks for writing it

    ReplyDelete