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

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Print |

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

June 06, 2008 00:03:49	#5
sravee123	Member Since: May 2008 Total Comments: 7
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;