Yestha

• Aug 2nd, 2007

 

select sysdate from dual

kowmudiswarna

 Profile Answers by kowmudiswarna Questions by kowmudiswarna

• Sep 13th, 2007

 

Hi ,
Try this query,

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

ashaRane

 Profile Answers by ashaRane 

• May 21st, 2008

 

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.

Sugumar.P

 Profile Answers by Sugumar.P 

• Jun 15th, 2008

 

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

sravee123

 Profile Answers by sravee123 

• Jun 17th, 2008

 

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

imtiazali

 Profile Answers by imtiazali 

• Jun 5th, 2009

 

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

younaskhan40

 Profile Answers by younaskhan40 Questions by younaskhan40

• Apr 20th, 2010

 

Select To_Char(SYSDATE,'DD-MON-RRRR HH:MI:SS AM') From Dual;

ranadhee_85

 Profile Answers by ranadhee_85 

• Feb 9th, 2011

 

SELECT sysdate FROM dual;