ReadVitamin

Somdev Devvarman ousts Xavier Malisse 6-1, 3-6,7-6(5)

Indian tennis pro and World Number 84 Somdev Devvarman surprised spectators in his third-round match against Belgian Xavier Malisse, defeating the 59thseed in 3 straight sets with a tie breaker. Devvarman secured his spot in the main draw of the Indian Wells tournament after fighting for two rounds in the qualifying matches. He defeated French player Adrian Mannarino in the first round and Marcos Baghdatis in the second round of the tournament. Devvarman will next face World [+]

How to use EXTRACT function with date and time columns

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 the output. Similarly for YEAR and DAY use the following commands SELECT EXTRACT (YEAR FROM date); SELECT EXTRACT (DAY FROM date); But for [+]