to_date function in bods is giving wrong results.
While I'm trying to convert the below string into date time its giving wrong results for the year 2015
But till 2014 it was working fine can you please help me with this code.
$G_Test = '01-JAN-15 17:30:35';
$G_DATE =to_char( $G_Test, 'DD-MON-YYYY hh24:mi:ss');
print('$G_DATE : [$G_DATE]') ;
Result is 1915.01.01 17:30:35 but the expected result is 2015.01.01 17:30:35 till 2014 it was working fine but after this year is converting to 19.
Hello Venkata S,
Please reference the following post: