MySQL Forums
Forum List  »  Partitioning

Re: Why is this an invalid hash function?
Posted by: Mikael Ronström
Date: May 12, 2006 02:01PM

Hi,
Can you supply the whole create table statement and the error you get.

Rgrds Mikael


avi weiss wrote:
> I want to have a hash value that is based on the
> full date, so I created this function, where
> pl_datetime is a datetime type:
>
> date_add(pl_datetime, interval 0 day)+0
>
> this functino appears to returm an int (ie
> 20060511), so not sure why that isnt valid, unless
> it is too large.
>
> any help would be helpful
>
> -avi

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Why is this an invalid hash function?
2513
May 12, 2006 02:01PM


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.