Interview Answer

Always code as if the guy who ends up maintaining your code will be a violent psychopath who knows where you live. Martin Golding

Write a SQL query to convert string to data format

April 10, 2016 6:39 pm

Comments



Write a SQL query to convert string to data format


The to_date function convert the string format date to the date format. When the developer want fetch the date format from the string, they can use to_date function. The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. The sysdate returns the current date from the oracle database server.


Solution

   					 select to_date('2013/12/10', 'yyyy/mm/dd')  from dual;				    

Comments



Please login to add comments.