Thread: Converting Varchar2 to Date getting prob

Thanks A Lot it worked

If you want this format (mm/dd/yyyy HH24.MI:SS) after updating the table, your update must be: Update Report Set Create_date = to_Char(to_date(Create_date, 'mm/dd/yy HH24:MI:SS' ), 'mm/dd/yyyy hh24:mi:ss' ) where trunc(Load_Date) = trunc(sysdate - 52) Max

Hi, Centinul wrote: Frank -- I can't view the link you posted. I think it has an extra "?" at the end. Thanks for pointing that out; it's fixed now. This site sometimes strips off the last number from the URL, the part that iedentifies the exact message within the thread. When that happens, you can always remove the non-digits from the end of the URL, as Boneist did, and read the whole thread.

It should be: this thread

Frank Kulash wrote: This site sometimes strips off the last number from the URL, the part that iedentifies the exact message within the thread. When that happens, you can always remove the non-digits from the end of the URL, as Boneist did, and read the whole thread. Frank -- Thanks. I understand and that's what I did. I just wanted to point it out to those folks that didn't know that didn't get confused.

I am just wondering, what is the datatype of create_date? I suspect you are trying to convert a date field into a character and then use that to update a date field - which will do an implicit conversion and fail because the date format you have does not match with the default nls_date_format. that is the only reason I can see how the following will work: select to_Char(to_date(create_date, 'mm/dd/yy HH24:MI:SS' ), 'mm/dd/yyyy...