Hi, Thank you for your message.
The standard SQL GREATEST() function should do what you are looking for. So just use DSL.greatest() as in e.g. DSL.greatest(MY_TABLE.COL1, MY_TABLE.COL2, MY_TABLE.COL3) Hope this helps, Knut On Wed, Jul 31, 2019 at 9:55 AM <[email protected]> wrote: > Hi, > > I have a table which contains three Timestamp columns. I wanted to find > the latest date from the three columns. > > How can i achieve that ? Any help would be greatly appreciated. > > Thanks, > Deba > > *Table* > *---------------------* > *Col1 Timestamp* > *Col2 **Timestamp* > *COl3 **Timestamp* > > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/6cee2833-3cfe-4e8e-beca-503aedd87653%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/6cee2833-3cfe-4e8e-beca-503aedd87653%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAFx%3DKgd393%2BaM%2BpCciKgeKS7ACx0%3DhLVLfd-%3DowkNz4p%2BOJkcg%40mail.gmail.com.
