Laurent Schneider

select 
  timestamp '2008-06-30 23:59:59.999999999 Europe/Zurich'-
  timestamp '1998-02-01 00:00:00 Europe/Zurich' 
from dual;
+000003802 22:59:59.999999999
select (
  timestamp '2008-06-30 23:59:59.999999999 Europe/Zurich'-
  timestamp '1998-02-01 00:00:00 Europe/Zurich' 
  ) year to month 
from dual;
+10-05

This is about the amount of time I spent by my former employer LC Systems. 10 years 5 months (d)

I will tune my book in July and start a new challenge in August

It is quite a while I have not posted about Linux. The reason is I have bought in new notebook three months ago with Vista and did not have a program to resize the partition…

Do I need a program?
NO, I do not !!!

Vista has disk management that can resize my online partition.

Run: compmgmt.msc /s
Or go to control panel.

And shrink/extend your volumes!

How do I get the current number of milliseconds since 1970-01-01.

I still have no access to oracle.com so I created a new account to answer this question.

Either you use the difference between timestamp ‘1970-01-01 00:00:00 +00:00′ and current_timestamp, or you can use java, which is more portable.

YMMV

create function epoch return number as language java name 
  'java.lang.System.currentTimeMillis() return int';
/ 
select epoch from dual;
           EPOCH
----------------
   1214562599878

One year ago I started writing a book on SQL. Writing a book is an amazing amount of work and I am glad I got helped from my five reviewers Chen, Andrew, Tom, Marco and Lutz.

It will ship in December 2008.

http://amazon.com/Advanced-Oracle-SQL-Programming-Focus/dp/0977671585

Since yesterday I cannot login to otn and to the forums

Probably I posted to much there

Since today I cannot login to Metalink

What should I expect for tomorrow?
No access to the internet?