SQL Plus - Which date function returns number value

GeekInterview.com

I am new, Sign me up!

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 43 of 132

Print

Which date function returns number value

Total Answers and Comments: 5

Last Update: May 06, 2007

Sponsored Links

Best Rated Answer

—

Submitted by: Lavanya Chowdary

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

Above answer was rated as good by the following members:
ashaRane

March 21, 2005 02:52:49

#1

Abhijit Mallick

RE: Which date function returns number value

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

Is this answer useful? Yes | No

March 30, 2005 17:04:27

#2

Ravi

RE: Which date function returns number value

Julian

Is this answer useful? Yes | No

November 21, 2005 01:08:29

#3

maheshwari

RE: Which date function returns number value

months_between

Is this answer useful? Yes | No

December 27, 2006 19:45:52

#4

sudhaker

RE: Which date function returns number value

to_char will also give number value

select to_char(hiredate 'd') from emp

Is this answer useful? Yes | No

May 06, 2007 07:03:38

#5

Lavanya Chowdary

RE: Which date function returns number value

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Sponsored Links

Sponsored Links

About Us - Privacy Policy - Terms and Conditions - Contact - Ask Question - Propose Category - Site Updates

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved