Date ISSUE
Dear Professionals,
I need to migrate data from a table to another table, the problem is FROM/SOURCE table having a field of varchar2 stored with date in format 'YYYY/MM/DD' and i need to migrate it to a table where date field is date, is there any way to convert the data from varchar to date before migrating, please help.
secondly, i have a field where employee full name is available from which i need to just take first name, is there any query to take first name out of full name by query, for example, "MALCOLM JOHNSON" is full name, i need to take only "MALCOLM", please help
I need to migrate data from a table to another table, the problem is FROM/SOURCE table having a field of varchar2 stored with date in format 'YYYY/MM/DD' and i need to migrate it to a table where date field is date, is there any way to convert the data from varchar to date before migrating, please help.
secondly, i have a field where employee full name is available from which i need to just take first name, is there any query to take first name out of full name by query, for example, "MALCOLM JOHNSON" is full name, i need to take only "MALCOLM", please help
0