Help understanding a query

MarieCline_Delgado

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

JoshuaBixby

Most of the SQL statement is straightforward, but there are a couple of things about the WHERE clause that are odd to me.  How are you extracting this query?  Are you copying and pasting it or typing it from what you seen on a screen?