"V.Ramkumar" wrote:

> Unable to round year. Please see below and provide solutions.

  I don't understand the question (I guess you want something different
than concat('20', year-on-2-digits)...)

  Regards,

-- 
Florent Georges
http://www.fgeorges.org/