4 Replies Latest reply: Nov 28, 2014 9:38 AM by mike de r RSS

    datetime to date

      Hello,

       

      I'm trying to group my datetimes to 1 record for each day.

       

      I found someting with timestamp and date(datetime, 'YYYY-MM-DD') but it's not working so far.

       

      My query is:

       

      LOAD "vessel_id",

          name as Route,

          datetime as "Date";

      SQL SELECT "vessel_id",

          name,

          datetime

      FROM route