August 22, 2017 at 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
August 22, 2017 at 1:46 pm
dilawarkhan1100 - Tuesday, August 22, 2017 1:21 PMhello 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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply