• Describe TO_DATE function in mysql?

    Describe TO_DATE function in mysql?

    Silver Member Asked on June 2, 2016 in MYSQL.
    Add Comment
  • 3 Answer(s)

    The TO_DATE function returns a timestamp from a character string that has been interpreted using a character template.TO_DATE is a synonym for TIMESTAMP_FORMAT.

    Silver Member Answered on June 2, 2016.
    Add Comment

    Write a syntax for To_Date function

     

    
     
    To_date('2003/07/09', 'yyyy/mm/dd') would return a date value of July 9, 2003.
    To_date('070903', 'MMDDYY') would return a date value of July 9, 2003.
    
    
    Silver Member Answered on June 2, 2016.
    Add Comment

    SELECT TO_DATE(‘January 15′,’MONTH DD’) “Sample” FROM DUAL

    Silver Member Answered on June 2, 2016.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.