Re: sql question
From: Joan Hsieh <joan.hsieh_at_tufts.edu>
Date: Tue, 05 Jan 2010 15:24:25 -0500
Message-ID: <4B439FF9.9030903_at_tufts.edu>
Thanks to all who reply my simple question. I thought the add_months was just working on month level, so I tried to manage the year and month separately which cause the confusion. After Jackie, Marc, Mei pointed it out, I finally realized how to use this add_months function correctly.
Date: Tue, 05 Jan 2010 15:24:25 -0500
Message-ID: <4B439FF9.9030903_at_tufts.edu>
Thanks to all who reply my simple question. I thought the add_months was just working on month level, so I tried to manage the year and month separately which cause the confusion. After Jackie, Marc, Mei pointed it out, I finally realized how to use this add_months function correctly.
Thanks again,
Joan
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jan 05 2010 - 14:24:25 CST