OQL: Cast Date/decimal/..

0
Hello,   i need a solution for using functions on OQL Queries like e.g. Select CAST(EKDatum AS string) From MainModule.Artikel   this works fine but the result is like 2023-03-11 23:00:00   So i would like to show only the date in a friendly way: 11.03.2023   Also something like trim, to cut unnecessary spaces..   Seems that no functions like substring or trim or… work with oql queries.   Somebody here with an idea of getting this more friendly?  
asked
1 answers
0

Hi everyone,

i solved this by a MF and loop through every object and manipulte the strings before i use them in a select statement.

This works fine and stable..

Thanks

 

Torsten

answered