Synopsis:
sys_datecvt(date,type)
Arguments:
date - The date to convert (YYYYMMDD or YYMMDD)
type - How to convert the date (0=day of week, 1=day of year)
Description: This function converts the specified date into a number that represents either the day of the week or the day of the year.
If type is set to 0 then the function will return a value that represents the day of the week 0 - 6 for Sunday - Saturday.
If type is set to 1 then the function will return a number between 0 and 364 (or 365 on a leap year) representing the day of the year.
Return Value:
Returns the day of the week or day of the year.