[Chartjs]-Call Column that is complex in query

by

1👍

✅

You can name the columns by defining column aliases:

SELECT to_char((nivo_prelivnik.date1 + nivo_prelivnik.time1), 'DD/MM/YYYY HH24:MI:SS') as col1,
       round(cast(izch_nivo*100 as numeric), 1) as col2,
       round(cast(debit as numeric), 3) as col3
FROM nivo_prelivnik;

Note the use of as after the expression. You can then refer to these in the result set.

Leave a comment