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, 2009 09:21:04	#6
imtiazali	Member Since: June 2009 Total Comments: 4
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;