In article <00bd01c52896$52a33400$0c0110ac@prenosil>, Ivan Prenosil wrote:

> > From: "Dimitry Sibiryakov"
> > 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?
>
> Normally no, but if it is part of converting from Timestamp/Date to (Var)Char
> then it works - just try it. (it is for compatibility reasons with older IB)

d_from is timestamp in dialect3 database inside an SP

d_from = '31.12.2004 13:45:17';
d_from = CAST(CAST (d_from AS VARCHAR(11)) as DATE);

gives truncation error (I want just the date portion of the initial contents)

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly