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?
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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.