Joined: 18 Jul 2007 Posts: 2150 Location: At my coffee table
Time pic x(8) to time pic 9(8)
If the x(8) is valid numeric (no spaces):
05 timex pic x(8).
05 time9 redefines timex pic 9(8).
move timex to time9.
If the x(8) is not valid numeric (some spaces):
Compute time9 = function numval (timex).
I have typed my column name as time..it is not time it is date column...
i need to convert my date field which is x(8)...CCYYMMDD..to 9(8) CCYYMMDD....
I hope now it is clear to alll
Thanks in advance