Posts Tagged ‘date’

Poker Face During Of Test

November 25th, 2013, posted in BoYs, COMiCS
Share

Poker Face During Of Test,Poker Face ,During Of Test,Poker, Face ,During the Test,test,boys,guys,date,time

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

ORACLE : How to Show / Get, Year Month and Date between two date ?

January 28th, 2013, posted in Oracle Queries
Share

Use 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.
*********************************************************************************************************************
Share

Oracle : How to Show Time with Date in a Session ?

January 8th, 2013, posted in Oracle
Share

If 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..!!!

 Time with Date in a Session of Oracle

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

FRiDAY 13th.. ; ]

May 13th, 2011, posted in DAtEs iN a YeAR
Share

                        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… ; ]


Share