SQL expression for MIN (timestamp)

2436
0
03-04-2015 01:35 PM
Highlighted
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.

Reply
0 Kudos
0 Replies