Oracle Date TO CHAR Month DD YYYY has extra spaces in it

Question

When I do     Select TO CHAR  date field   Month DD  YYYY   from      I get the following   July      01  2011 April     01  2011 January   01  2011   Why are there extra spaces between my month and day   Why doesn t it just put them next to each other

User · Answer

select to char sysdate   DD-fmMONTH-YYYY    Date  from Dual   The above query result will be as given below   Date  01-APRIL-2019

User · Answer

SQL gt  -- original       SQL gt  select   2  to char  sysdate   Day  the  Ddth  of  Month  yyyy    dt   3  from dual   DT ---------------------------------------- Friday    the 13th of May        2016  SQL gt  SQL gt  -- collapse repeated spaces       SQL gt  select   2  regexp replace    3      to char  sysdate   Day  the  Ddth  of  Month  yyyy       4                    datesp   5  from dual   DATESP ---------------------------------------- Friday the 13th of May   2016  SQL gt  SQL gt  -- and space before commma       SQL gt  select   2  regexp replace    3      to char  sysdate   Day  the  Ddth  of  Month  yyyy       4                     1    datesp   5  from dual   DATESP ---------------------------------------- Friday the 13th of May  2016  SQL gt  SQL gt  -- space before punctuation       SQL gt  select   2  regexp replace    3      to char  sysdate   Day  the  Ddth  of  Month  yyyy       4                           1    datesp   5  from dual   DATESP ---------------------------------------- Friday the 13th of May  2016

User · Answer

You should use fm element to delete blank spaces   SELECT TO CHAR sysdate   fmDAY DD  de  MONTH  de  YYYY   CURRENT DATE FROM   dual

User · Answer

Why are there extra spaces between my month and day  Why does t it just put them next to each other    So your output will be aligned      If you don t want padding use the format modifier FM   SELECT TO CHAR  date field   fmMonth DD  YYYY      FROM        Reference  Format Model Modifiers

User · Answer

if you use  Month  in to char it right pads to 9 characters  you have to use the abbreviated  MON   or to char then trim and concatenate it to avoid this  See  http   www techonthenet com oracle functions to char php  select trim to char date field   month              to char date field  dd  yyyy     from       or  select to char date field  mon dd  yyyy     from

User · Answer

try this -  select to char to date  01 10 2017   dd mm yyyy    fmMonth fmDD YYYY   from dual   select to char sysdate  fmMonth fmDD YYYY   from dual

[sql] Oracle Date TO_CHAR('Month DD, YYYY') has extra spaces in it

Date

Examples related to sql

Examples related to oracle

Examples related to oracle10g