How to get System time in SQL?

deeprashi

 Profile Answers by deeprashi Questions by deeprashi

• Mar 1st, 2010

SELECT sysdate FROM dual (It will show time as well as date)

kondapallikalyan

 Profile Answers by kondapallikalyan Questions by kondapallikalyan

• Nov 24th, 2009

We have Functions1. current_timestamp2. systimestampEx: Select current_timestamp from dual;Ex:Select systimestamp from dual;

Answer Question  Select Best Answer