Home Forums Programming General Date RE: Date

  • August 22, 2017 at 1:46 pm

    #1956242

    dilawarkhan1100 - Tuesday, August 22, 2017 1:21 PM

    hello every one,i want to insert date into  one of the column in a table but i am unable to insert date because of the issue "day of month must be between 1 and last day of month"  although i used the to_date function in the values

    No one knows what the the data you are trying to convert looks like and the error and function are for Oracle. So it might be the third line or a problem towards the bottom of that script. Try changing the format mask as the month in the string is not seen as a valid month. If that doesn't work, migrate the database to SQL Server.
    Oracle / PLSQL: TO_DATE Function

    Sue