aciu uz pagalba, meginsiu pratestuoti

On 3/22/2011 10:04 AM, 2x50 wrote:
> with x as (select to_timestamp(sysdate) ts1, to_timestamp(sysdate+1) ts2
> from dual)
>
> select sum(cast(ts2 as date)-cast(ts1 as date)) from x
>
> "news"<netikrasmailas@gmail.com>  wrote in message
> news:im9rol$5al$1@trimpas.omnitel.net...
>> prie to pacio:
>> turiu timestamp1 ir timestamp2
>> man reikia atlikti operacija sum(timestamp1-timestamp2)
>> kaip tai padaryti?
>
>