topic SQL expression for MIN (timestamp) in Data Management Questions https://community.esri.com/t5/data-management-questions/sql-expression-for-min-timestamp/m-p/102127#M5986 <HTML><HEAD></HEAD><BODY><P>I'm working in ArcMap, in the Select by Attributes dialog on a PostgreSQL Enterprise GDB feature class.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I'm using a SQL expression for MIN (timestamp) to <STRONG>get most recent feature</STRONG> created.&nbsp; MAX() seems to work fine, but MIN() is not working.&nbsp; </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><PRE class="sql" name="code">"created_date" = (SELECT MIN("created_date") FROM sde.sde.AlertSite)</PRE><DIV style="display:none;"> </DIV><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>On verify: The expression was verified successfully, but no records were returned.</P></BODY></HTML> Wed, 04 Mar 2015 21:35:09 GMT DavidTreering 2015-03-04T21:35:09Z SQL expression for MIN (timestamp) https://community.esri.com/t5/data-management-questions/sql-expression-for-min-timestamp/m-p/102127#M5986 <HTML><HEAD></HEAD><BODY><P>I'm working in ArcMap, in the Select by Attributes dialog on a PostgreSQL Enterprise GDB feature class.</P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>I'm using a SQL expression for MIN (timestamp) to <STRONG>get most recent feature</STRONG> created.&nbsp; MAX() seems to work fine, but MIN() is not working.&nbsp; </P><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><PRE class="sql" name="code">"created_date" = (SELECT MIN("created_date") FROM sde.sde.AlertSite)</PRE><DIV style="display:none;"> </DIV><P style="min-height: 8pt; padding: 0px;">&nbsp;</P><P>On verify: The expression was verified successfully, but no records were returned.</P></BODY></HTML> Wed, 04 Mar 2015 21:35:09 GMT https://community.esri.com/t5/data-management-questions/sql-expression-for-min-timestamp/m-p/102127#M5986 DavidTreering 2015-03-04T21:35:09Z