Re: Why is this an invalid hash function?
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
Subject
Views
Written By
Posted
5656
May 12, 2006 08:04AM
Re: Why is this an invalid hash function?
2513
May 12, 2006 02:01PM
2611
May 12, 2006 03:37PM
2276
May 28, 2006 03:11AM
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.