Welcome! Log In Create A New Profile

Ass 1 Q4

Posted by Darkling

Announcements		Last Post
	SoC Curricula	09/30/2017 01:08PM
	Demarcation or scoping of examinations and assessment	02/13/2017 07:59AM
	School of Computing Short Learning Programmes	11/24/2014 08:37AM
	Unisa contact information	07/28/2011 01:28PM

Forums Messages New

Darkling

Ass 1 Q4
November 16, 2011 10:05AM

Registered: 15 years ago
Posts: 234
Rating: 0

The question asks whether if the following will display as "17 of June 1987" true or false

select last_name,
to_char(hire_date,'fmDd "of" Month YYYY' winking smiley

HIREDATE
FROM EMPLOYEES

I have it as true but the solutions says false.

Any Comments?

Reply Quote

Jaxy

Re: Ass 1 Q4
November 16, 2011 10:58AM

Registered: 14 years ago
Posts: 38
Rating: 0

Heya,

According to the book....

select last_name,
to_char(hire_date,'fmDd "of" Month YYYY' winking smiley

AS HIREDATE
FROM EMPLOYEES

I also got this one wrong... sad smiley

Reply Quote

nozdlax

Re: Ass 1 Q4
November 16, 2011 12:22PM

Registered: 14 years ago
Posts: 134
Rating: 0

Hi

I also had it as true. If you actually execute it, it works.

Reply Quote

kumar06

Re: Ass 1 Q4
November 16, 2011 05:04PM

Registered: 12 years ago
Posts: 18
Rating: 0

Yup works for me too eye popping smiley