Oracle Function: EXTRACT()

thatjeffsmith Database Stuff 0 Comments

Question: How do I find the hour portion of the value between to timestamps? Answer: Use the EXTRACT() function! Thankfully @TheRealLewisC (twitter | blog) pointed us in the right direction! I was tempted to do a subtraction and then a substr() to pull out just …

My Oracle Twitter List

thatjeffsmith Database Stuff 2 Comments

Are you new to Twitter, and need people to follow to get the conversation started? If you work with Oracle, then please continue reading. Don’t forget to check out @BrentO’s Twitter Book! I harangued (definition) my colleague and close friend this morning until he relented …