SQL expression for MIN (timestamp)

03-04-2015 01:35 PM
New Contributor II

I'm working in ArcMap, in the Select by Attributes dialog on a PostgreSQL Enterprise GDB feature class.


I'm using a SQL expression for MIN (timestamp) to get most recent feature created.  MAX() seems to work fine, but MIN() is not working. 


"created_date" = (SELECT MIN("created_date") FROM sde.sde.AlertSite)


On verify: The expression was verified successfully, but no records were returned.

0 Kudos
0 Replies