On 14 Mar 2005 at 13:33, Ivan Prenosil wrote:

>To strip-off time portion from timestamp, you have to convert
>string 'NOW' to timestamp, get first 11 characters,
>then convert it back. This will work in both dialects:
> CAST(CAST(CAST ('NOW' AS DATE) AS VARCHAR(11)) AS DATE)

AFAIK, CAST cannot truncate string. You'll get 'String truncation'
error, no?
--
SY, Dimitry Sibiryakov.