Postgres SQL TIME column

#1

Hi what is Time column and metric column. actually used for when creating dashboard with postgres datasource.

I have created a table
CREATE TABLE COMPANY(
ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL
Times Date
);

and inserted data as:

INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, ‘Paul’, 32, ‘California’, 20000.00, ‘2019-10-12’);
INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS) VALUES (2, ‘Allen’, 25, ‘Texas’, 30000.00, ‘2019-10-13’);

but i am not able to represent it as graph. Please guide me with the query to be used in this case. and what will be filled in “Time Column” and “MEtric Column”.

Thanks.
Vinay

#2

If you select these queries can you see the date field (in the same format) ?

#3

yes i can see the same date format

#4

Could you show us the query in the Graph panel? You must include always the time reference