Which date function returns number value

Showing Answers 1 - 9 of 9 Answers

Abhijit Mallick

  • Mar 21st, 2005
 

months_betweenThis date function takes 2 valid dates and returns number of months in between them.

Ravi

  • Mar 30th, 2005
 

Julian

  Was this answer useful?  Yes

maheshwari

  • Nov 21st, 2005
 

months_between

  Was this answer useful?  Yes

sudhaker

  • Dec 27th, 2006
 

to_char will also give number value

select to_char(hiredate,'d') from emp

  Was this answer useful?  Yes

Lavanya Chowdary

  • May 6th, 2007
 

months_between(date1,date2) returns the number value
no other date functions return number value

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions