Welcome!
Log In
Create A New Profile
Home
>
2011
>
INF307H
> Topic
Advanced
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'
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'
AS HIREDATE
FROM EMPLOYEES
I also got this one wrong...
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
...damm the solution
Reply
Quote
Newer Topic
Older Topic
Print View
RSS
Sorry, only registered users may post in this forum.
Click here to login