AnsweredAssumed Answered

Concatenate function in nsql  - dynamic wry for display value

Question asked by prakashm on Aug 15, 2011
Latest reply on Oct 13, 2017 by giriraj.gupta1
Hi
I was trying to concatenate two date fields in a dynamic lookup to get a display value. Below is the query.
Select @select:c.code@,
@select:c.name@,
@select:c.start_date:start@,
@select:c.finish_date:finish@,
@select:to_char(c.start_date,'dd/mm/YY')||' '||to_char(finish_date,'dd/mm/YY'):sfdate@
From rqp_releases c where @FILTER@

When I save I get the following syntax error...
Unable to register dynamic wry........'to_char' is not a recognized built I. Function ........

Can anybody help me on this where I went wrong.......appreciate your help.

Thanks
Pmp

Outcomes