How do you display "13th of November, 17 days left for
month end" without hardcoding the date.
- 3 Answers
- 6383 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
tell us something about heap tables. : Sql dba
What is restrict in sql?
What is delimiter in pl sql?
Is not null in sql?
What is a pl/sql block?
What is write ahead logging in sql server?
how to drop an existing index in mysql? : Sql dba
How many triggers can be applied on a table?
How is sql used in oracle?
What is dml and ddl?
What is pessimistic concurrency control? : Transact sql
Why sql query is slow?
Is left join faster than join?
Where the sql database files are stored?
What is the size of partition table?
