Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Allentown pa
    Posts
    41

    Unanswered: Convert Char to Date datatype

    Hello all, I want to convert a filed thats defined as char(10) with data looking like mm/dd/yyyy to date data type. Any easy way? Thanks in advance Jeff
    Jeff Wain

  2. #2
    Join Date
    Aug 2003
    Location
    Allentown pa
    Posts
    41
    I got it there was some bad data in ome columns that was not in mm/dd/yyyy format fix those and altered the data type thanks anyway Jeff
    Jeff Wain

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •