1 Reply Latest reply: Apr 28, 2017 8:34 AM by Peter Rieper RSS

    Compare Timesamp from Hive Data with another Timestamp

    Max Joseph

      How do I compare a TimeStamp with another one:

       

       

      this works:

      LET vIE = 'WHERE $(vMF) >=#' & date(peek('maxdate'),'MM/DD/YYYY') &'#';

       

       

      this one doesn't :

       

      LET vIE = 'WHERE $(vMF) >=#' & timestamp(peek('maxdate'),'MM/DD/YYYY hh:mm:ss') &'#';


      the data is given as:


      16.01.2016 09:20:22

      .

      .

      .

      It always gives back: some mistake near >= ..