For that you can refer this two threads.
and you can also check this link
Returns a datetime that combines a date and a time. The date can be a date, datetime, or a string type. The time must be a datetime. This function is available only for MySQL connections.
Thanks and regards,
so i understand that the conversion (in live mode on AS/400) can be only in the "direct SQL" mode.
Yes , May I know the datasource.
datasource is (as i wrote twice) is AS-400.....
Ohhh Its new for me. Thanks I learned something today