So, this is New Year. Seems like the year 2007 has just begun and moved ahead in First Forward mode throughout and today it is going to be a history soon. This is “Time”, one of the rarest things that can not be bought at discount but always available at par and we almost always [...]

Popularity: 43% [?]

Click here to read more

Using Extract function with any date field is easy. Let’s try this out with system date and system time commands. To see the current date we use
SELECT DATE;
This would give output as “11/06/2007″. Suppose you want to EXTRACT the month from the date then use this query
SELECT EXTRACT (MONTH FROM date);
This would give “11″ as [...]

Popularity: 61% [?]

Click here to read more