New.fieldname = cast(new.fieldname as char(11))

----- Original Message -----
From: Duilio Foschi <dedalus@...>
To: <ib-support@yahoogroups.com>
Sent: Wednesday, 15 May, 2002 6:59 PM
Subject: [ib-support] removing the TIME part from a TIMESTAMP


> the use of timestamps in a dialect 1 database is giving to me unwanted
> headaches.
>
> Porting the database to dialect 3 is in the to-do list, but it takes time.
>
> I wonder if it is possible to truncate the TIME part of the field inside a
> before-insert trigger, so that all the fields will point to
> somedate:00:00:00 .
>
> How do I do that ?
>
> TIA
>
> Duilio Foschi
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>