user13355933 wrote:The date-format looks absolutely fine, in both cases being +'dd-MON-yyyy'+
the format of dates goes wrong
user13355933 wrote:And what are the data types of the columns? And if the data passing through any systems outside of the database, what is the format there?
Hi I have database jobs that upload the data in my applications.
My problem is while copying the record of one application to another, the format of dates goes wrong
The date in one column is 01-JAN-1941
but in the other record while copying ot goes as 01-JAN-2041.