Weekday function in oledb

Discussion created by PeterJ on Oct 23, 2013
Latest reply on Oct 29, 2013 by Bannikov

In Classic OLEDB the WEEKDAY function takes a timestamp and returns an interger corresponding to the day of the week - 1=Sunday , 2= Monday...7=saturday


I don't think it is documented (?)


Is there a way of doing this in OLEDB enterprise ?


incidently both classic and enterprise OLEDB also seem to support a "week" function which returns the week number - again I can't see it in the documentation.