aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fn_match_day
Parameters
Name
Type
Mode
adate
date
IN
days
t_days
IN
Definition
SELECT CASE EXTRACT(dow FROM adate) WHEN 0 THEN days.sun WHEN 1 THEN days.mon WHEN 2 THEN days.tue WHEN 3 THEN days.wed WHEN 4 THEN days.thu WHEN 5 THEN days.fri WHEN 6 THEN days.sat END