This is how to extract month or year from Oracle (placing it here so I don't forget)
By Month -
SELECT EXTRACT(month FROM order_date) "Month",
COUNT(order_date) "No. of Orders"
FROM orders
GROUP BY EXTRACT(month FROM order_date)
ORDER BY "No. of Orders" DESC;
By Year -
SELECT EXTRACT(YEAR FROM DATE '1998-03-07') FROM DUAL;
For more info, look at this page:
http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions050.htm
See PDF for more SQL References:
http://docs.oracle.com/cd/B19306_01/server.102/b14200.pdf
2 comments:
Hello! Would you mind if I share your blog with my twitter group?
There's a lot of people that I thinmk would really enjoy your content.
Please let me know. Many thanks
my blog post; apartment in tampa fl ()
Good day! I know this is kind of off topic but I was wondering if you knew where
I could locate a captcha plugin for my comment form? I'm using the same blog platform
as yours and I'm having problems finding one? Thanks a lot!
Feel free to visit my page - Cambogia Plus Review (www.netonfree.In)
Post a Comment