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
personal
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!
vista, windows
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
Blogroll, java, sql
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
11g, Blogroll, book, sql, xml
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?
personal, support