Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

oracle sql all days except weekends

WHERE TO_CHAR(date_column, 'DY','NLS_DATE_LANGUAGE=AMERICAN') NOT IN ('SAT', 'SUN')
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #oracle #sql #days #weekends
ADD COMMENT
Topic
Name
9+1 =