| Subject | Re: [firebird-support] Grabbing only date portion of Timestamp? |
|---|---|
| Author | Daniel Rail |
| Post date | 2004-07-07T10:52:39Z |
Hi,
At July 6, 2004, 20:03, Joe Martinez wrote:
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. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)
At July 6, 2004, 20:03, Joe Martinez wrote:
>>What is the dialect of the database? If it's dialect 1, then you'll
>>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.
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. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)