SQL Plus - How can we use of select query to get the current date and time?

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 125 of 132

How can we use of select query to get the current date and time?

Total Answers and Comments: 6

Last Update: June 06, 2009 Asked by: XXXX

Sponsored Links

Best Rated Answer

—

Submitted by: kowmudiswarna

Hi ,
Try this query,

seelct to_char(sysdate,'dd/mm/yy hh:mi:ss') from dual;

Above answer was rated as good by the following members:
vibhavdoshi78

August 02, 2007 01:22:48

Yestha

current date & time

select sysdate from dual

Is this answer useful? Yes | No

0 1

Overall Rating: -1

September 13, 2007 13:43:16

kowmudiswarna

Member Since: September 2007 Contribution: 21

RE: How can we use of select query to get the current ...

Hi
Try this query

seelct to_char(sysdate 'dd/mm/yy hh:mi:ss') from dual;

Is this answer useful? Yes | No

1 0

Overall Rating: +1

May 21, 2008 10:48:45

ashaRane

Member Since: May 2008 Contribution: 1

RE: How can we use of select query to get the current date and time?

We will get the current date and time with the help of below mention select query.

select to_char(current_date 'dd-mon-rr hh:mi:ss') from dual;

Asha Rane.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

June 15, 2008 01:14:55

Sugumar.P

Member Since: June 2008 Contribution: 1

RE: How can we use of select query to get the current date and time?

Hello Friend kowmudiswarna
Your answer is correct but the keyword select is typed wrongly

Is this answer useful? Yes | No

June 17, 2008 00:03:49

sravee123

Member Since: May 2008 Contribution: 24

RE: How can we use of select query to get the current date and time?

select to_char(sysdate 'dd/mm/yy hh:mi:ss') from dual;

Is this answer useful? Yes | No

1 0

Overall Rating: +1

June 05, 2009 09:21:04

imtiazali

Member Since: June 2009 Contribution: 11

RE: How can we use of select query to get the current date and time?

select to_char(sysdate 'dd-mm-yy hh24:mi:ss')from dual;

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank