Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
How can i concatenate 2 dates already in the same table. REC_DATE and INV_DATE ?
Hi,
try like
REC_DATE &'_'& INV_DATE as NEW_DATE.
Regards
Give this fields unique single name like
Load
REC_DATE,
REC_DATE as NewDateField
Load From tableName;
Concatenate
Load
INV_DATE,
INV_DATE as NewDateField
Load From tableName;
but the REC_DATE and the INV_DATE are in the same table.