AnsweredAssumed Answered

SQL expression for MIN (timestamp)

Question asked by dgoldb2@luc.edu on Mar 4, 2015

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.

Outcomes