Opened 9 years ago
Closed 5 years ago
#6115 closed defect (wontfix)
MSSQL connection reading DateTime field as string(length)
| Reported by: | maxa | Owned by: | warmerdam |
|---|---|---|---|
| Priority: | normal | Milestone: | closed_because_of_github_migration |
| Component: | OGR_SF | Version: | unspecified |
| Severity: | normal | Keywords: | formatting, MSSQL, Date, DateTime |
| Cc: | tamas |
Description
Hi, I am struggling to get Date or DateTime fields out of MSSQL queries with either ogrinfo or ogr2ogr. I originally thought the issue was with ogr2ogr so was investigating the -mapFieldTypes switch. When executing the following statement to ogrinfo: ogrinfo "MSSQL:server..." -sql "SELECT * FROM <schema>.<table>" -so
date fields are returned as (for example) createdate: String (10.0)
The corresponding sql table field type is (date,null)
Change History (2)
comment:1 by , 9 years ago
| Cc: | added |
|---|---|
| Component: | Utilities → OGR_SF |
comment:2 by , 5 years ago
| Milestone: | → closed_because_of_github_migration |
|---|---|
| Resolution: | → wontfix |
| Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
This ticket has been automatically closed because Trac is no longer used for GDAL bug tracking, since the project has migrated to GitHub. If you believe this ticket is still valid, you may file it to https://github.com/OSGeo/gdal/issues if it is not already reported there.