Oracle Date TO_CHAR(‘Month DD, YYYY’) has extra spaces in it

by

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

More Related Contents:

  1. Merging two tables in SQL [closed]
  2. Is it possible to output a SELECT statement from a PL/SQL block?
  3. Pivoting rows into columns dynamically in Oracle
  4. Using ‘case expression column’ in where clause
  5. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  6. Concatenate results from a SQL query in Oracle
  7. How to use BOOLEAN type in SELECT statement
  8. How to kill a running SELECT statement
  9. Selecting the second row of a table using rownum
  10. Update with Join query in Oracle
  11. How to count the number of occurrences of a character in an Oracle varchar value?
  12. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  13. Oracle date “Between” Query
  14. ORA-01861: literal does not match format string
  15. Query a Table’s Foreign Key relationships
  16. Is there an Oracle equivalent to SQL Server’s OUTPUT INSERTED.*?
  17. How to compare clob columns of single table in oracle? [closed]
  18. SQL function PIVOT with 2 column
  19. Oracle SQL pivot query
  20. Oracle SQL, concatenate multiple columns + add text
  21. SQL Error: ORA-01861: literal does not match format string 01861
  22. Determine Oracle null == null
  23. INSERT SELECT statement in Oracle 11G
  24. SELECT INTO using Oracle
  25. SQL Oracle LEFT JOIN and SUBQUERY error: ORA-00905: missing keyword
  26. `show create table` equivalent in oracle sql
  27. ORA-00972 identifier is too long alias column name
  28. How to use a dynamic parameter in a IN clause of a JPA named query?
  29. Backup SQL Schema Only?
  30. IN vs OR of Oracle, which faster?

Leave a Comment