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

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Print |

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

September 09, 2007 13:43:16	#2
kowmudiswarna	Member Since: September 2007 Total Comments: 14
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;