MySQL Forums
Forum List  »  Partitioning

Re: Partition by Date Column
Posted by: Lee Gillentine
Date: January 28, 2009 02:08AM

Speaking of YEARMONTH, this is the hack I use to get that function:

SELECT MONTHNAME(timestamp), YEAR(timestamp) FROM table

Not very efficient, but it gets the job done

Options: ReplyQuote


Subject
Views
Written By
Posted
17455
July 05, 2006 10:23AM
5778
July 24, 2006 09:01AM
5174
September 04, 2006 09:56PM
4523
September 05, 2006 05:07PM
6036
September 06, 2006 01:34AM
4082
October 03, 2006 12:06PM
5103
October 03, 2006 09:04PM
3965
October 25, 2006 08:45AM
3880
October 26, 2006 11:24PM
Re: Partition by Date Column
3752
January 28, 2009 02:08AM
3785
March 19, 2009 01:35AM
3571
April 06, 2009 08:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.