Posts Tagged ‘date’
ORACLE : How to Calculate Average of Date Values ?
February 25th, 2013, posted in Oracle QueriesAre 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.
*****************************************************************************************************************
ORACLE : How to Show / Get, Year Month and Date between two date ?
January 28th, 2013, posted in Oracle QueriesUse bellow sql to show year month and date :
SELECTÂ Â Â TRUNC (MONTHS_BETWEEN (:END_DATE, :START_DATE) / 12) as YEARS,
MOD(TRUNC (MONTHS_BETWEEN (:END_DATE, :START_DATE)), 12) as MONTHS,
(Â TO_DATE (:END_DATE)- ADD_MONTHS (:START_DATE,TRUNC (MONTHS_BETWEEN (:END_DATE, :START_DATE))))Â as Date
FROM DUAL;
********************************************************************************************************************* Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as well. *********************************************************************************************************************
Oracle : How to Show Time with Date in a Session ?
January 8th, 2013, posted in OracleIf your want to show time with date in your sql environment like, working with Sql Developer or Sql Plus or iSql Plus then change the value of NLS_DATE_FORMAT.
To change the value log in the sql environment and write:
alter session set NLS_DATE_FORMAT =’DD-MON-RRRR HH:MI:SS AM’;
then check the value…you are done..!!!
*********************************************************************************************************************
Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as
well.
*********************************************************************************************************************
FRiDAY 13th.. ; ]
May 13th, 2011, posted in DAtEs iN a YeAR
                        FRiDAY 13th
For all of u out dere…
hAPPYÂ FRiDAY dE Â Happy Friday the 13th… ; D
i mean com’on guys…its not like end of de world or anythng..
though many guys where killed n died on FRiDAY…n sumwhere on FRiDAY 13..so wht..?? ; ]
u r stil alive…
n mayb so m i.. ;D
n u knw whts de funny thng.. 😀
i m starting mY BLoGGiNG….
mY real own BLoGGinG oN FRiDAY 13th… ;D
Anyway…
i would 1st like 2 tel abt FRiDAY 13th…
Friday de 13th occurs when de 13th day of a month falls on FRiDAY, which mostly…n commonly superstition holds 2 be a day of bad LUCk…In de GREGORiAN CALENDAR, dis day occurs at least 1ce..but at most 3 times a year..
(hvnt read or send tht calender n hv no offense abt it either.. ; ] )
by de way…
it is said tht..
Any month’s 13th day wil fall on a Friday…if the month starts on a Sunday… 😀
intesesting naa…
de funny thng is more 2 come.. ; ]
according 2 more of mY tiny little search.. ;D
de fear of Friday the 13th is called friggatriskaidekaphobia ( FRiGGA being de name of de Norse goddess 4 whom “Friday” is named n triskaidekaphobia meaning fear of de number thirteen).. or paraskevidekatriaphobia a concatenation of deGreek words Paraskevà (ΠαÏασκευή, meaning “Friday”)…n dekatreÃs (δεκατÏείς, meaning “thirteen”) attached 2 phobÃa (φοβία, from phóbos, φόβος, meaning “fear”). ..The latter word was derived in 1911 …n..first appeared in a mainstream source in 1953….
SeessHHHhhh…
dy even hv dis big words 4 tht.. ; ]
anyway…
de turth is I dnt gv a dammn abt it.. ; ]
I lv FRiDAY..
its de most blessing day 4 mE… ; ]
I spent tym with mY FAMiLY…
sumtyms with FRiENDS as well.. ; ]
so i dnt care wht thy say…
I lv FRiDAY n whtever date is it on..
n 2 prove tht I hv written all tht n posting on FRiDAY 13th… ; ]