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

What is the best IDE for C and C++ development?
If you're a student then Turbo C++ is best for C and C++ program + inbuilt C/C++ Graphics Function If you're a professional or working then Netbeans for C/C++ or Code:: Blocks is Best.
Balakrishnasingh
SVM is applicable only for numeric data or can also be for textual data?
SVM can work with textual data also. However you have to train the SVM to classify the text data. It is a usual practice to create a document-term matrix from the text that you have, to make SVM work easily on the data.
Harsha
I am working in a nontechnical field and i want to switch this job and work in a technical field but I am not able to decide where to start. I want to learn, but what in Python?
I can help you make a blasting entry in technical profile. You can learn Informatica+Oracle and one real time project with me. It should be enough for your future growth.
Raksha
Where can I get Python online training?
You can get many institutes in google which are providing online training.
Taranum
What are the main weaknesses of Python as a programming language?
Python’s main weaknesses include slower performance compared to compiled languages, limited support for mobile development, higher memory consumption, and the Global Interpreter Lock (GIL), which can restrict multi-threading efficiency.
Raj
0 0
View Comments5

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

Ask a Question

Related Lessons

Contents Of C++ Programming
1. History of CPP 2. Concepts of OOP's 3. Introduction and Features of CPP (OOP's) 4. Characteristics of OOP's 5. CPP Keywords 6. Major Components of CPP: Encapsulation Inheritance Polymorphism 7....

Vilas D.

0 0
View Comments0
Why Do People Choose Python?
Lot of programming languages are available in the market today, but why do people choose python over them? What made it different from other scirpting languages. So factors made it unique, as below: Software...

Venu

0 0
View Comments0
Read Your Gmail Emails Using PHP and IMAP
Hello Friends ,Recently I have worked on drip email campaign project for that I need to read emails using PHP From the gmail inbox. Here is the simple example for Read emails from the gmail: To start...

Swadesh

3 0
View Comments5
How to know if an object is iterable?
An object in python is said to be an iterable if it obeys one of the following two rules:- 1. Object must consist of __getitem__ method 2. Object must consist of __iter__ method. String objects generally...
D

Deleted User

0 0
View Comments0
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
View Comments0

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 Pune
Programming Languages Classes in Chennai
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