I want to convert integer into date format.
Database 1 : import_date(field)(value is in format ddmmyyyy - e.g 10012003)
Datebase 2 : importdate(field) Format is datetime
I want to store the integer (dateformat) from Database 1 into Database 2 as dd/mm/yyyy.
Again, i have got integer as ddmmyyyy and i want to save it into a database which has format as datetime as dd/mm/yyyy.
Pls urgently reply required.
Need to write stored procedure for this one.