| Subject | removing the TIME part from a TIMESTAMP |
|---|---|
| Author | Duilio Foschi |
| Post date | 2002-05-15T16:59:35Z |
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
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