• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Informix equalent of Oracle's GREATEST() function?

 
Siva Prasad Reddy Katamreddy
Ranch Hand
Posts: 32
Eclipse IDE Spring Tomcat Server
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I have a table with 3 date columns and i want to find the maximum of 3 columns.

For Ex:
Table : EMPLOYEE(ID, Date1, Date2, Date3)

Now i want to execute the query:
SELECT ID, GREATEST(DATE1,, Date2, Date3) MAX_DATE FROM EMPLOYEE;

But Informix doesn't have support for GREATEST() function.

How can i do it in Informix?

Thanks,
Siva
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic