String to Date

Hi

I’m trying to convert the date field which is in string datatype to To_date …

I have some blank spaces in the field which is giving error in the place of blank spaces …

Its working for the null values and for the date but in the blank spaces place its giving me error…


pathu (BOB member since 2010-08-05)

Hi,

Depending on where the blank spaces are, try using either the TRIM() function or the Replace() function to remove the blank spaces.


Marek Chladny :slovakia: (BOB member since 2003-11-27)

I found out that the issue is something related to format type.

for now I have changed the comparison date object to string and that is working fine for the logic I’m using.


pathu (BOB member since 2010-08-05)