score:1
Accepted answer
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.
Source: stackoverflow.com
Related Query
- call Column that is complex in query
- django chart.js - Query to get count of all distinct values for particular column
- Sql Server query that returns prices from each shop on each date and adds a 0 if no data is present for the shopId on a particular date
- How to run Chart.js samples using source code
- Laravel DB select statement. Query returns column name as result rather than values
- How to clear a chart from a canvas so that hover events cannot be triggered?
- chart.js stacked graph that overlaps
- laravel query builder with conditions
- chart js tooltip how to control the data that show
- Different color for each column in angular-chartjs bar chart
- Syntax Error: Token '{' invalid key at column 2 of the expression [{{id}}] starting at [{id}}]?
- Chart.js - generateLegend() call results in "undefined is not a function"
- How to make fixed width of column without ticks.min/max in chart.js?
- How to show only the data points that have a change in Chartjs?
- is there a way to call a Component's function from click function of Chartjs
- How to add ChartJS code in Html2Pdf to view image
- Iterate over query for use in Charts.js using Coldfusion
- ChartJs - Pie Chart - how to remove labels that are on the pie chart
- How can I change color of only one column in Barchart using Chart.js
- How to add background image in bar chart column in Chart.js?
- Possible to hide Chart.js grid lines that extend beyond chart?
- How to remove border from stacked column chart in Chartkick - Chart.js
- Chart.js error: type lacks a call signature '((...items: number[]) => number) | ((...items: ChartPoint[]) => number)' in Angular
- Chart.js - Vertical crosshair (vertical annotation that moves with mouse) in line graph
- How to create a chart that uses strings for both the X and Y axes?
- chart.js add second line in a Line chart that starts from end of first line
- How do I add time sourced from an external source as an X axis to a ChartJS graph?
- ChartJS - Finding the minimum and maximum labels that are inside a pan (When zooming)
- How to rename properties in objects that are in an array. What is the right way to solve the task?
- Beginner using chart.js: having trouble display state full of data into a column chart using variables
More Query from same tag
- Data is not display in correct order after update
- Sort a Chart from Lowest to Highest Value in Chart JS
- chart.js:4 Uncaught ReferenceError: require is not defined in ionic 2
- angular-chart.js bar chart with 100% opacity color
- Angular-charts/Chart.js is not working
- Chart.js Line, different fill color for negative point
- ng2-charts - bar chart, showing only one color
- Problem to create dynamic pie chart in ChartJS
- How to rotate datalabels in Charts.js with plugins?
- generator-angular-fullstack and angular-chart.js not displaying charts
- Chart js how to toggle line without click
- Chart.js multiple series with same scale
- Angular Chart.js, how to remove series?
- Point unselection in ChartJS
- Adding model data to Charts.js in Rails
- Charts js not showing
- Canvas static height Chartjs
- How to update with animation a Pie Chart?
- Custom tooltip styling in Chart.js
- Javascript object from string
- Chart.js disappears on Android
- ChartJS customize left and bottom axe border
- Chart.js: A value is empty, but the line must not be broken
- Chart.js - Responsiveness not correctly working on device orientation change
- chart.js radar scaleShowLine for each scaleLine
- How to add text inside scatter plot using Chart.js?
- how to make realtime update chart like in package express-status-monitor?
- How to remove or color line/grid in polar chart area using Chart.js?
- Stacked Floating Horizontal Bar using ChartJS
- How to properly render Chartjs with big difference between bars data?