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
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity and sql server 4 67
Oracle programming for starter 14 76
FUN:  Brainstorming Categories and names for Tech-themed dog Names 20 85
Developers / Staff Setup 10 48
Displaying an arrayList in a listView using the default adapter is rarely the best solution. To get full control of your display data, and to be able to refresh it after editing, requires the use of a custom adapter.
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

710 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