i need set day portion of date in oracle retain month , year. can tell me do?
e.g. if date 01-jan-15 want set day 15 15-jan-15.
1* select sysdate, trunc(sysdate, 'month')+14 dual sql> / sysdate trunc(sysda ----------- ----------- 25-sep-2015 15-sep-2015 sql>
Comments
Post a Comment