CODEWITHSUNDEEP
c#postgresqldatedatetimepsql
xyz
xyz

Reputation: 549

How does PostgreSQL stores DateTime with no timezone

I am new to PostgreSQL database and not sure how the DateTime without time zone is stored. I am trying to retrieve the fields in my c# and not sure what is the format specifier of a DateTime without time zone of a psql field in c#. I see two different formats for the same data type

enter image description here

Can I give yyyy-MM-dd HH:mm:ss.fff as format specifier for both the fields in c#.

Upvotes: 1

Views: 7031

Answers (1)

Leo C
Leo C

Reputation: 22449

PostgreSQL's timestamp without time zone does take the 2017-03-20 15:45:00 format with resolution down to sub-millisecond. As to mapping to .NET's native data type, you might want to take a look at this.

Upvotes: 3

Related Questions