分类文章

热门文章

oracle add_months函数

oracle add_months函数

oracle add_months(time,months)函数可以得到某一时间之前或之后n个月的时间

如 select add_months(sysdate,-6) from dual;

该查询的结果是当前时间半年前的时间

select add_months(sysdate,6) from dual;

该查询的结果是当前时间半年后的时间

随机文章



分享生活也赚钱,赶快加入吧

Loading…

相关文章:

  1. Oracle10g的SQL正则表达式
  2. ORA-01006: bind variable does not exist
  3. Non supported character set: oracle-character-set-852
  4. oracle 树状查询 connect by prior start with
  5. oracle 合并列数据

请给本文打分   
1 Star2 Stars3 Stars4 Stars5 Stars (4 votes, average: 3.00 out of 5)
Loading ... Loading ...

Leave a Reply

 

 

 

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word