Interview Answer

In software, we rarely have meaningful requirements. Even if we do, the only measure of success that matters is whether our solution solves the customerís shifting idea of what their problem is. Jeff Atwood

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.