Changed the date format for the recent uploads.

SimonGoring · SimonGoring · commit b638b96d63bd · 2020-10-29T09:09:57.000-07:00
Function now returns dates as YYYY/MM/DD format (year, month, day). Changes pushed to `neotoma` and `neotomatilia`. Resolves issue #10.
diff --git a/function/ti/getrecentuploads.sql b/function/ti/getrecentuploads.sql
@@ -11,7 +11,7 @@ AS $function$
         	end as geopolitical,
           cdb.databasename,
           STRING_AGG(pic.contactname, '; ') AS investigator,
-          to_CHAR(ds.recdatecreated, 'text') AS recdatecreated,
+          to_CHAR(ds.recdatecreated, 'YYYY/MM/DD') AS recdatecreated,
    		    STRING_AGG(ct.contactname, '; ') as steward
   FROM ndb.datasets AS ds
     INNER JOIN         ndb.datasettypes AS dst ON dst.datasettypeid = ds.datasettypeid
