Subject Re: [firebird-support] Grabbing only date portion of Timestamp?
Author Daniel Rail

At July 6, 2004, 20:03, Joe Martinez wrote:

>>update table2 set MyDate = (select cast(SomeDate as Date) from Table1
>>where Table1.KeyField = Table2.KeyField )

> I just tried that, and it didn't work. The time portion still came over.

What is the dialect of the database? If it's dialect 1, then you'll
need a UDF to extract the date portion. Because under dialect 1, the
datatype DATE is the equivalent of TIMESTAMP in dialect 3, and that
there's no equivalent for dialect 3's DATE and TIME datatypes.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (