I am trying to TRIM a date field ( MNC_dt DATE FORMAT 'YY/MM/DD') as it had some trailing spaces form the source data but the resule of trim is changing the date format, any reason?
Original value is = 2/2/2006
After trim it changed to = 06/02/02
i need help on triming columns,
am using one fexp script lik this
.EXPORT OUTFILE ------;
MODE RECORD FORMAT TEXT;
as char (1000))
my query like this..
and expected outputis like this
but actual result
how to remove the all space in between records