Posted on 2004-04-07
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.
Question by:usfusfusf
LVL 65

Accepted Solution

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

Assisted Solution

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>;


Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Report events not being triggered 8 100
squareUp  challenge 22 105
countHi challenge 25 84
VB 6.0 printer how to align 6 49
RIA (Rich Internet Application) tools are interactive internet applications which have many of the characteristics of desktop applications. The RIA tools typically deliver output either by the way of a site-specific browser or via browser plug-in. T…
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…
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

707 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now