how to truncate date and get only time part 9:20:00
Answer Posted / sandeep
select to_char(sysdate,'HH24:MM:SS') from dual;
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
How to fetch the row which has the max value for a column?
How to convert dates to characters in oracle?
What is a read only transaction in oracle?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to create lov dynamically at runtime & attach to text field?
What is oracle analytical function?
How to pass parameters to procedures in oracle?
What exactly do quotation marks around the table name do?
How to connect ms access to oracle servers?
What is oracle server autotrace in oracle?
What are the attributes of the cursor?
How to initialize variables with default values?
How to sort the query output in oracle?
Is oracle a relational database?
What is a snapshot log?