DSXchange

I am selecting date column from a table in OCI stage and putting into sequential file. but in sequential file dat is not showing in proper format.

I have tried with to_char for date column while selecting but it's not showing in proper format. can anyone please help me?

First we'd have to have some clue what you consider "proper format" to be.