select hire_date, to_char(hire

How do you display "13th of November, 17 days left for
month end" without hardcoding the date.

Question Posted / prativa mishra

3 Answers
7350 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

Please Help Members By Posting Answers For Below Questions

Why coalesce is used in sql?

1005

How do I run a program in pl sql?

1000

How do I debug a stored procedure?

1110

Why do we use procedures in pl sql?

1035

What do you mean by field in sql?

1076

How many types of indexes are there in sql?

983

Is sql a microsoft product?

946

Is record in oracle pl sql?

958

Can we use commit inside a trigger?

1086

Are dml statements autocommit?

1040

Is primary key a clustered index?

966

What is the use of triggers?

1034

what are the different functions in sorting an array? : Sql dba

1014

What are the different types of dbms?

1009

Does access use sql?

1037