on 11-11-2016 12:06 PM
Dear,
I need to impplement the Date Functions semester in the Query Transform but It does not exist but quarter yes:
quarter(Date_Generation.DI_GENERATED_DATE)
How can I implement the same for semester ?
How can I simulate a function "X" ? that returns me the semester using functions that exists
Maybe can I use a custom Function????
X (Date_Generation.DI_GENERATED_DATE) ?????'
Thanks in advance.
Kind Regards.
Antonio
Depending on your definition of semester, use decode function in combination with date functions, e.g.
decode(quarter(Date_Generation.DI_GENERATED_DATE) in (1,2), 1,2)
decode( month(Date_Generation.DI_GENERATED_DATE) between <your range for first semester>, 1, 2)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.