Using oracle server 7.3 and VB5/Prof, I try to retrieve a record that one of the columns, CALLDATE, is defined as date.
The SQL statment is:
Set rsinvoice = dbsRemote.OpenRecordset("select PIN_NO,to_char(CALLDATE,'MM/DD/YYYY') from [ALON.INVOICE] order by PIN_NO", dbOpenSnapshot, dbRunSync)
But when executing this statment I gor an error:
3085:undefined function 'to_char' in expression.
My question is why VB doesn't recorgnize this function, and how can I make it recognize the function?