Issue when comparing result of to_char(myDate, ‘DAY’) to a string

by

If you want to be really robust about this then you ought to force the NLS setting to English and apply the “fill mode” format model FM for trimming leading and trailing spaces.

If To_Char(DateC,'fmDAY', 'nls_date_language=english') = 'FRIDAY'
Then ...

More Related Contents:

  1. REGEX to select nth value from a list, allowing for nulls
  2. PLS-00428: an INTO clause is expected in this SELECT statement
  3. Sleep function in ORACLE
  4. Subtracting Dates in Oracle – Number or Interval Datatype?
  5. How to call Oracle MD5 hash function?
  6. Using bind variables with dynamic SELECT INTO clause in PL/SQL
  7. Receive an unexpected symbol error in my PLSQL query [closed]
  8. PL SQL UPDATE STATEMENT
  9. Search All Fields In All Tables For A Specific Value (Oracle)
  10. Is it possible to output a SELECT statement from a PL/SQL block?
  11. SQL to generate a list of numbers from 1 to 100
  12. Oracle Joins – Comparison between conventional syntax VS ANSI Syntax
  13. create table with sequence.nextval in oracle [duplicate]
  14. IF EXISTS condition not working with PLSQL
  15. How to get the last row of an Oracle table
  16. Using pivot on multiple columns of an Oracle row
  17. Is there any way to flush output from PL/SQL in Oracle?
  18. INSERT SELECT statement in Oracle 11G
  19. Oracle – How to create a materialized view with FAST REFRESH and JOINS
  20. Solution to “cannot perform a DML operation inside a query”?
  21. PLSQL Insert into with subquery and returning clause
  22. How to query a CLOB column in Oracle
  23. Display names of all constraints for a table in Oracle SQL
  24. Oracle 11g – Check constraint with RegEx
  25. How to use a dynamic parameter in a IN clause of a JPA named query?
  26. Creating or simulating two dimensional arrays in PL/SQL
  27. Oracle string aggregation
  28. How to check if a column exists before adding it to an existing table in PL/SQL?
  29. Curious issue with Oracle UNION and ORDER BY
  30. Insert into from CTE

Leave a Comment