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
7217 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

define data blocks ? : Sql dba

932

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1158

What is difference between procedure and trigger?

919

how to convert character strings to numeric values? : Sql dba

1026

How to run sql functions in pl/sql?

992

Is sql low level language?

963

How do you optimize a stored procedure query?

939

What is int identity in sql?

1064

What are different types of statements supported by sql?

1099

How do you delete a table?

1001

Do ddl statements need commit?

925

What are sql objects?

1014

What do you know by pl/sql cursors?

1037

What is a Mapplet?

1057

What has stored procedures in sql?

996