

http://unicorn.ü-wie-geek.de/0.2/128/f79b395a801bf291b74e8bccea8e03f8.png
http://unicorn.ü-wie-geek.de/0.2/32/f79b395a801bf291b74e8bccea8e03f8.png
http://meta.stackoverflow.com/questions/37328/my-godits-full-of-unicorns
Various recommendations that have come to me via email. Dear BLOGGER checker, I am a REAL PERSON, see one of the drafts where I have given you my phone number to reach me.
To convert a UNIX timestamp into an Oracle DATE type:
CREATE OR REPLACE
FUNCTION unixts_to_date(unixts IN PLS_INTEGER) RETURN DATE IS
/**
* Converts a UNIX timestamp into an Oracle DATE
*/
unix_epoch DATE := TO_DATE('19700101000000','YYYYMMDDHH24MISS');
max_ts PLS_INTEGER := 2145916799; -- 2938-12-31 23:59:59
min_ts PLS_INTEGER := -2114380800; -- 1903-01-01 00:00:00
oracle_date DATE;
BEGIN
IF unixts > max_ts THEN
RAISE_APPLICATION_ERROR(
-20901,
'UNIX timestamp too large for 32 bit limit'
);
ELSIF unixts < min_ts THEN
RAISE_APPLICATION_ERROR(
-20901,
'UNIX timestamp too small for 32 bit limit' );
ELSE
oracle_date := unix_epoch + NUMTODSINTERVAL(unixts, 'SECOND');
END IF;
RETURN (oracle_date);
END;
CREATE INDEX lsc_i ON lsc_t(NAME);
SELECT /*+INDEX(LSC_T,LSC_I)*/ ID, NAME, birthdate
FROM lsc_t WHERE NAME LIKE '%ABC%';
"But the more blatant lesson of Avatar is not that American imperialism is bad, but that in fact it’s necessary. Sure there are some bad Americans—the ones with tanks ready to mercilessly kill the Na’vi population, but Jake is set up as the real embodiment of the American spirit. He learns Na’vi fighting tactics better than the Na’vi themselves, he takes the King’s daughter for his own, he becomes the only Na’vi warrior in centuries to tame this wild dragon bird thing. Even in someone else’s society the American is the chosen one. He’s going to come in, lead your army, fuck your princesses, and just generally save the day for you. Got it? This is how we do it."