1.

How Will You Convert String To A Date In Oracle Database?

Answer»

This Oracle Interview QUESTIONS is some time asked as follow up of previous Oracle Interview questions related to CONVERTING date to char in Oracle. By the WAY to_ date function is USED to convert string to a date function.
Syntax : to_date(string, format)

Example: to_date('2012/06/12', 'yyyy/mm/dd') It will return June 12, 2012

This Oracle Interview questions is some time asked as follow up of previous Oracle Interview questions related to converting date to char in Oracle. By the way to_ date function is used to convert string to a date function.
Syntax : to_date(string, format)

Example: to_date('2012/06/12', 'yyyy/mm/dd') It will return June 12, 2012



Discussion

No Comment Found