About the conversion of oracle's to_char to doris

[liujiwen-up]

Usage of to_char in oracle，to_char('2009-10-04 22:23:00', 'yyyymm' and to_char(t, 'FM99999999990.00)
Format conversion for date and value respectively，However, there is no such function in doris that takes into account both, so whether it can be realized in the form of conversion according to the situation
self.validate_all( "to_char('2009-10-04 22:23:00', 'yyyymm')", write={ "doris": "DATE_FORMAT('2009-10-04 22:23:00', 'yyyymm')", }, ), self.validate_all( "to_char(t, 'FM99999999990.00')", write={ "doris": "Round(t,2)", }, ),

[georgesittas]

Based on https://www.techonthenet.com/oracle/functions/to_char.php, it seems like this needs quite some effort to transpile correctly. You'd need to go through the different Oracle TO_CHAR formats and handle them specially in Doris.

[liujiwen-up]

What I mentioned above is divided into numerical format and date format for conversion, can’t it?

[georgesittas]

Yes, that separation makes sense. However, your previous approach doesn't seem correct, based on the above docs.