Re: Why is this an invalid hash function?

[Mikael Ronström]

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