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

Explain the select statement in sql?

1115

What are predefined functions in sql?

1049

What are the two parts of design view?

1020

what is transaction? : Sql dba

1011

What do you understand by case manipulation functions?

1036

What is sql and db2?

1012

Explain the insert into statements in sql?

1010

Why function is used in sql?

951

What is the command used to fetch first 5 characters of the string?

1404

how does a local variable is defined using t-sql? : Transact sql

1021

What are all the different types of indexes?

1150

What are different types of tables in sql?

999

Is join same as left join?

1042

what are the features and advantages of object-oriented programming? : Sql dba

1013

What is procedure explain with example?

968