Which date function returns number value?

Asked by Last Modified  

4 Answers

Follow 0
Answer

Please enter your answer

months_between(date1,date2) returns the number value...and to_char will also give a number value ...
Comments
Dislike Bookmark

Software Professional Trainer with 26+ years of Experience in Software Design and Development

Oracle SQL Plus : months_between(first_date1,second_date) returns the number value
Comments
Dislike Bookmark

Coaching

MONTHS_BETWEEN (x1, x2), Returns the number of months between dates x1 and x2. MONTHS_BETWEEN : This date function takes 2 valid dates and returns number of months in between them.
Comments
Dislike Bookmark

DATEVALUE(text) converts a date in the form of text to a number that represents the date in MS-Office Excel Date-Time code.
Comments
Dislike Bookmark

View 2 more Answers

Related Questions

How to contact teacher?
Hi Kritika, You can search for the best teachers on UrbanPro and once you find the appropriate teacher profiles, you can directly call the teachers by dialing number. Regards Sunita
Kritika
2 0
8
what is method over-riding and how it is used ? if possible send with code with output or screen photo ?
Method over-riding : it is a technique in which more then one function with same name and same signature( similar type parameter) can present in program. in overriding a subclass method overrides the definition...
Sayyad
0 0
5
How can I develop my C language?
To develop your skills in the C programming language, consider the following steps: 1. Learn the Basics: Start with understanding the fundamental concepts of C, such as variables, data types, operators,...
Himanshu
0 0
5
Can include files be nested?
Yes. Include files can be nested any number of times. As long as you use precautionary measures, you can avoid including the same file twice. In the past, nesting header files was seen as bad programming...
Himangi
0 0
7
I know some basics of c, how much time will I require more to reach a good/advance level in c?
It is about 3 to 4 months according to me..
Akash

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

Recursion in C Programming
The process of calling a function by itself is called recursion and the function which calls itself is called recursive function. Syntax of Recursive Function returntype recursive_func () { statements; ...
R

Ravindra Yadav

2 0
0
Handbook of websites for Website Developers/Designers (software professionals)
Know the trending languages(past & present) and their comparision with other languages: @ https://www.tiobe.com/tiobe-index/ Found an interesting website? identify the technologies used to build...

B V Krishna Pernamitta

0 0
0
Pointers Concept
Every variable has a memory location and every memory location has its address defined which can be accessed using ampersand (&) operator, which denotes an address in memory. Consider the following...

Sudarshan Gupta

0 0
0
Internet of Things, Social Media Becoming Part of E-Discovery Landscape
The days when e-discovery consisted of handing over copies of e-mails to address Freedom of Information Act (FOIA) requests, compliance regulations or other legal obligations are over. Now, it's just as...

Rajesh N V

3 0
1
C Program-String Palindrome
//Header files #include<stdio.h>#include<conio.h>#include<string.h> //Main function void main(){ char mystring; int i,length; int flag=0; //Function for clearing screen clrscr();...

Salim Ahmed Ansari

0 0
0

Recommended Articles

Learn Hadoop and Big Data

Hadoop is a framework which has been developed for organizing and analysing big chunks of data for a business. Suppose you have a file larger than your system’s storage capacity and you can’t store it. Hadoop helps in storing bigger files than what could be stored on one particular server. You can therefore store very,...

Read full article >

Make a Career as a BPO Professional

Business Process outsourcing (BPO) services can be considered as a kind of outsourcing which involves subletting of specific functions associated with any business to a third party service provider. BPO is usually administered as a cost-saving procedure for functions which an organization needs but does not rely upon to...

Read full article >

Learn Microsoft Excel

Microsoft Excel is an electronic spreadsheet tool which is commonly used for financial and statistical data processing. It has been developed by Microsoft and forms a major component of the widely used Microsoft Office. From individual users to the top IT companies, Excel is used worldwide. Excel is one of the most important...

Read full article >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

Read full article >

Find Programming Languages Classes near you
Programming Languages Classes in Bangalore
Programming Languages Classes in Hyderabad
Programming Languages Classes in Delhi
Programming Languages Classes in Chennai
Programming Languages Classes in Pune
Programming Languages Classes in Mumbai
Programming Languages Classes in Kolkata
Programming Languages Classes in Noida
Programming Languages Classes in Gurgaon
Programming Languages Classes in Ghaziabad

Looking for Programming Languages Classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you