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?

May 05, 2008 10:48:45	#3
ashaRane	Member Since: May 2008 Total Comments: 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.