EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

Error "Datetime field overflow" pops up when querying against PostgreSQL warehouse where the table contains timestamp datatype column


Junjie Shi

Quality Engineer, Senior • MicroStrategy


Error "Datetime field overflow" will pop up when querying against PostgreSQL warehouse where the table contains timestamp data type column.

Issue Description

When user is executing report against PostgreSQL warehouse where the table contains timestamp data type column. Below error might occur. The issue will occur when the timestamp (without time zone) column has value larger than 9999-12-31 24:00:00.000000000.

ka04W000000XPCtQAO_0EM4W000001KFq3.jpeg

Workaround:


User could use the timestamp with time zone data type instead of timestamp without time zone. And the issue could be workaround. 
Reference https://www.postgresql.org/docs/current/datatype-datetime.html
 


Comment

0 comments

Details

Knowledge Article

Published:

December 28, 2020

Last Updated:

December 28, 2020