Select to view content in your preferred language

Specify field datatypes when registering database view with geodatabase

268
1
01-17-2024 08:14 PM
Status: Open
Labels (1)
Bud
by
Esteemed Contributor

ArcGIS Pro 3.2.1; mobile geodatabase


I have a mobile geodatabase standalone table that has a date field:

Bud_0-1705550814673.png

Bud_1-1705550814732.png

And I have a database view that aggregates rows using GROUP BY. However, the date field is displayed incorrectly as a DOUBLE.

--latest_vw
select min(objectid) as objectid, t_species, max(t_date) as t_date from species_records group by t_species

Bud_4-1705550814558.png

Bud_5-1705550814799.png

I would like to permanently define the field as a date when registering the view with the geodatabase. So that the field is treated as a date in ArcGIS Pro.

1 Comment