Interested to Buy Any Domain ? << Click Here >> for more details...
How do you display "13th of November, 17 days left for
month end" without hardcoding the date.
- 3 Answers
- 7474 Views
- I also Faced
- E-Mail Answers
Answer Posted / prativa mishra
select hire_date,
to_char(hire_date,'ddth')||' '||'of'||'
'||to_char(hire_date,'month')||','||(last_day(hire_date)-
hire_date)||'days left for month end' aa
from
employees
where TO_DATE(HIRE_DATE,'DD-MON-RRRR')=&HIRE_DATE
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is trigger in flip flop?
what is the functionality of the function htmlentities? : Sql dba
What is sql*loader and what is it used for? : aql loader
Why use stored procedures?
What is the difference between inner join and left join?
How do you determine the current isolation level? : Transact sql
What is audit logout in sql profiler?
What is rollback?
Is inner join faster than left join?
How do you optimize a stored procedure query?
What is primary key secondary key alternate key candidate key?
what is 'mysqldump'? : Sql dba
What are stuff and replace function?
What sql database should I use?
What is sql profiler in oracle?
