Powerhouse QUIZ

[Shedboy]

Does anyone out there know if there is a QUIZ function for getting the name of the day from the date?

i.e. I have the date in normal format, 02/08/03, I need it to return SATURDAY.

There is a SQL function (TO_CHAR(T1."DATE" ,'DAY') and a Cognos Impromptu function (dayname(date)) but I can't find anything for QUIZ.

Any help appreciated.

SB

 

[JamesLean]

What is a "QUIZ function"?

In T-SQL you can use the DATENAME function:

SELECT DATENAME(dw, getdate())

--James

 

[SQLBill]

There ISN'T any TO_CHAR in MICROSOFT SQL SERVER. You are probably using ORACLE. If so, please post in the correct forum.

-SQLBill