Wednesday, May 18, 2011

Calaculating No of Years between 2 dates

The query is


SELECT TIMESTAMPDIFF(YEAR,'1987-02-13',now());

enjoy....
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Hide Query By Example of PanelCollection on page load

Hi All, If there is a table with filterable is true. If you want to display QueryByExample then surround this table with panelCollection....

  • Select Many Choice use in ADF
    Hi All, if we want to select multiple values from the list box then we will make use of inbuilt component "af:selectmanychoicebox"...
  • varStatus variable in ADF table
    There is an inbuilt feature in ADF table called varStatus variable, which can be used to display a auto increment number for any dummy colu...
  • Calling Java Methods From Jasper Reports
    To call java methods from jasper reports. Just Follow the following steps Step1: create a java class with a static method which r...