How to set time with seconds and without date and timezone in PSQL

Asked Mar 03 '17 at 08:50

Active Mar 03 '17 at 09:20

Viewed 27 times

I have a problem with pslq database when I connect it with C# application. When I fill the datagridview with data from PSQL database, I get this type of data:

What I need is type of time: HH:mm:ss ONLY, so for ex. in this case: 08:48:00. Can someone tell me what type of data I need to set that column to in PSQL database?

P.S. My database column that I fill datagridview with looks like this in PSQL database:

Data type in PSQL for that column:

edited Mar 03 '17 at 09:20

Manfred Radlwimmer

13,257
13
53
62

asked Mar 03 '17 at 08:50

Marko Petričević

the data in db looks as you want. Look into datagridview instead – Vao Tsun Mar 03 '17 at 09:16
Depending on how you actually fill your grid you are missing a `StringFormat`, or a `String.Format`. A [mcve] would definitely help here. – Manfred Radlwimmer Mar 03 '17 at 09:21

How to set time with seconds and without date and timezone in PSQL

0 Answers0