Select to view content in your preferred language

SQL expression for MIN (timestamp)

2777
0
03-04-2015 01:35 PM
DavidTreering
Emerging Contributor

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