AnsweredAssumed Answered

Help understanding a query

Question asked by MCline19 on Jan 23, 2020
Latest reply on Jan 24, 2020 by MCline19

Looking for a little help understanding what the Where clause of this SQL query is doing. This is used to define a query layer in an ArcPro map.  DBMS is postgresql

 

SELECT

   a.id, a.valid_date, a.id, a.name, a.net, a.elevation, a.mph, a.local_time, a.shape
FROM

   obs.gusts AS a
WHERE

   ::r:DateTime

 

I understand that the last line is a cast function, but I do not understand what the "r" represents and how it's filtering the data.

 

Thanks in advance

Outcomes