Archive for February, 2013

Ohh Yeah

February 26th, 2013, posted in BoYs, COMiCS
Share

Ohh Yeah,hit it,jackpot baby,guys,boys,boy,men,man,

Share

A Snap Of Last Night Power-Outage

February 25th, 2013, posted in PAKiSTAN
Share

A Snap Of Last Night Power-Outage,Snap,Last Night Power-Outage,A Snap,Last Night,Sukker, Nawabshah, Rohri ,Electricity,lahore,HUBCO Power Plant,HUBCO, Power Plant,technical fault, Power-Outage,light off,pakistan blackout,KESC,

Share

ORACLE : How to Calculate Average of Date Values ?

February 25th, 2013, posted in Oracle Queries
Share

Are you getting trouble of calculating average time of a filed, where data type is date time ?
Don’t worry. You are at right place to get right solution.

I’m going to calculate average time of a filed.
If there is two time value in a day, i will calculate the first one means minimum one.

SELECT TO_CHAR(TRUNC(SYSDATE)+AVG(VDATE-TRUNC(VDATE)),’HH24:MI:SS’)
FROM (SELECT MIN(DDATE) VDATE
FROM DEPT
GROUP BY TRUNC(DDATE))

****************************************************************************************************************
Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as
well.
*****************************************************************************************************************
Share

What Happen In Iraq By Usa

February 24th, 2013, posted in Art, COMiCS, UNiVERSE
Share

What Happen In Iraq By Usa,Iraq,usa,united states of america,america,

Share

Green Lantern- Muslim Edition

February 24th, 2013, posted in COMiCS
Share

Green Lantern, Muslim Edition,Green Lantern- Muslim Edition,Green Lantern,Muslim,Islam

Share