I would like to concatenate a date and time coming from a specific table into a single column, but I get the following message:Operator requirements are not met. Operator 'CONCAT' is not compatible with inputs of type DATE. Is there some workaround to concatenate DATE type?

Solved

What to use for concatenating date and time using PQL?

+2

I would like to concatenate a date and time coming from a specific table into a single column, but I get the following message:

Error message Operator requirements are not met. Operator 'CONCAT' is not compatible with inputs of type DATE.

Is there some workaround to concatenate DATE type?

Best answer by salma.zeped

Found the solution after more investigation. I'd like to share, in case someone finds it useful:

TO_STRING("AUFK"."ERDAT" , FORMAT ( '%Y-%m-%d')) || ' ' || TO_STRING("AUFK"."ERFZEIT", FORMAT ( '%H:%M:%S' ))

I simply needed to convert the data type from date to string and set the format that I required.

+2

Found the solution after more investigation. I'd like to share, in case someone finds it useful:

TO_STRING("AUFK"."ERDAT" , FORMAT ( '%Y-%m-%d')) || ' ' || TO_STRING("AUFK"."ERFZEIT", FORMAT ( '%H:%M:%S' ))

I simply needed to convert the data type from date to string and set the format that I required.