Hi,
I am looking for a simple solution to remove the time portion of a date time.
The problem is I select from an Oracle DB with SQL passthough and I recieve
always the time portion and the users don't want this. I need to be able
to change this without extensive coding for example with a SET TIMEPART OFF
or SET DATE command as apposed to a valid,refresh coding syntax.
Any ideas?

TIA
BR
Tim