0/0/0000 date in Sybase ASE
Posted: Tue Jan 16, 2018 9:57 pm
Hello all,
I am having trouble with extracting out a record in the Sybase ASE database with a date format of "0/0/0000". When the record is extracting or viewed inside the stage, it comes out as ";877" which is obviously not a valid date format.
The job format I have is just taking the table and using RCP to load into Oracle, so I cannot explicitly convert the year.
Any thoughts?
Thanks in advance.
I am having trouble with extracting out a record in the Sybase ASE database with a date format of "0/0/0000". When the record is extracting or viewed inside the stage, it comes out as ";877" which is obviously not a valid date format.
The job format I have is just taking the table and using RCP to load into Oracle, so I cannot explicitly convert the year.
Any thoughts?
Thanks in advance.