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

Name three sql operations that perform a sort.

1066

Which nosql database is best?

1025

what are the advantages of using stored procedures? : Sql dba

1157

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3110

Write the command to remove all players named sachin from the players table.

1230

What is substitution variable?

1098

Explain dml and ddl?

1059

What is a unique key?

1106

Is big data nosql?

1000

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

4464

How is indexing done in search engines?

1023

How to raise user-defined exception with custom sqlerrm ?

1182

What are different types of tables in sql?

1052

Why use triggers in sql?

1013

How do I run a sql script?

1233