At 02:46 PM 23/11/2004 +0200, you wrote:

>How can I only get DATE portion of a TIMESTAMP;
>
>I have a field that is of type TIMESTAMP I would like to have a computed
>field that stores ony the "date" portion and not the TIME portion.

MyDate COMPUTED BY CAST(MyTimestamp AS DATE)

Tip, if you want to use this field for searching or ordering, you'd do
better to add the DATE column outright, ***index it*** and populate it with
before insert and before update triggers.

./hb