-
Sql query help
SQL> select hiredate , next_day(hiredate,'SATURDAY') from emp where ename='SMITH';
HIREDATE NEXT_DAY(
--------- ---------
17-DEC-80 20-DEC-80
i want to know the exact day when smith hired,how to get this, from above query i am getting first SATURDAY of his joining,
-
huh? Wouldn't that be hiredate?
Jeff Hunter
-
do you mean:
to_char(hiredate, 'DAY')
Assistance is Futile...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|