Skip to Main Content

Japanese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

date,timestamp型への演算について

teradata0802Nov 26 2013 — edited Nov 26 2013

Oracle11gR2を使っています。

date、timestamp,timestamp WITH TIME ZONE,timestamp WITH LOCAL TIME ZONE 型のデータに加算、減算をするにはどうすれば

よいでしょうか?

1日前とか1時間前とか30分前とかです。

sysdate - ???, systimestamp - ???

This post has been answered by yamamoto on Nov 26 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 24 2013
Added on Nov 26 2013
2 comments
4,321 views