I'm waiting for your oracle - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

I'm waiting for your oracle

I'm waiting for your oracle# Database - 数据库

s*n2000-01-25 08:01

1 楼

I appreciate your kind answers.
my question is :
can I change a DATE type(eg. 1999/10/10 10:15:00) to total seconds from 1970/1/1,
like time() function in UNIX ? In fact,I want to calculate date in Pro*c.
when I get many records where the date is in DATE type shown above,how can I
calculate the time difference between two records? And what's more,how can I
add a duration(eg. 10 minutes) onto a date and write it back?

B*n2000-01-25 08:01

2 楼

select old_date+(1/24/60)*10 from dual;
the above sql will add 10 minutes to 'old_date'. For instance:
SQL> select to_char(sysdate, 'MM-DD-YYYY HH24:MI:SS') "current time" from dual;
current time