Solved

Get_date

Posted on 2004-04-07
4
560 Views
Last Modified: 2012-06-21
Hi All,
I want to know how to use Get_date function in oracle developer. if possible please send example.
thanks
0
Comment
Question by:usfusfusf
4 Comments
 
LVL 65

Accepted Solution

by:
rockiroads earned 25 total points
ID: 10782110
by get_date do u mean the current date?

you would normally use sysdate to get the current date
0
 
LVL 2

Assisted Solution

by:yongyih
yongyih earned 25 total points
ID: 10783766
select to_char(sysdate,'dd/mm/yyyy') from dual;

select to_char(sysdate,'dd/mm/yyyy') from <table name>;


can?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question