MySQL Forums
Forum List  »  General

Re: how use a TIMESTAMP and compare it with a MAX of another TIMESTAMP
Posted by: Peter Brawley
Date: April 09, 2014 01:46PM

Is this what you mean?

select a.*                                              
from table1 a
join (
  select name, max(timestamp(tickdate,ticktime)) as timemax 
  from table2
  group by name
) x on a.name=x.name and timestamp(a.giorno,a.orario) < x.timemax;

Options: ReplyQuote


Subject
Written By
Posted
Re: how use a TIMESTAMP and compare it with a MAX of another TIMESTAMP
April 09, 2014 01:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.