Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I have a postgres database with a series of fields that includes a date field in MM/DD/YYYY format. Through ArcSDE it displays in Arc in a weird format with the wrong date and some made up time.

When viewed via PGAdmin or QGIS the date displays correctly. Does anyone have an idea of why Arc is jumbling the date and how it can be corrected?

The screenshot below shows the attribute table for identical rows in QGIS and Arc. Notice how Arc includes a random time and the wrong date (everything is year 2000).

enter image description here

share|improve this question
1  
What version of PostgreSQL? What version of ArcGIS? What version of ArcSDE? What does 'sdetable -o describe' say the type is? Which date type are you using? –  Vince Nov 27 '13 at 17:10

1 Answer 1

up vote 8 down vote accepted

ArcSDE uses 'struct tm' to pass date fields, so it certainly has the range to support the information. I suspect, however, that you're not using the supported date type (TIMESTAMP WITHOUT ZONE), which is causing the date to get mangled.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.