vicky ece wrote: What is the difference between DAY_OF_WEEK and DAY_OF_WEEK_IN_MONTH.?why i am getting different output for the same date...
Output is : My Uncle BirthDay is going to be on the day :Monday
Output is : My Uncle BirthDay is going to be on the day :SUNDAY
Why the output varies and the actual date is SUNDAY.. Any idea....
I believe you are confusing what DAY_OF_WEEK_IN_MONTH actually returns. It didn't return MONDAY. It returned the number 2. So, basically, your uncle's birthday is on a SUNDAY, specifically, the second SUNDAY of the month.
Henry