Subject | Re: [firebird-support] ISC_TIMESTAMP vs. Current Time |
---|---|
Author | Kurt Federspiel |
Post date | 2007-05-06T18:54:23Z |
The data type of the field (in the DB) is TIMESTAMP.
That is the issue I'm having that I can't figure
out....
I finally broke down an bought the Firebird Book
(online) and discovered I can CAST the field result to
a CHAR(24), but that does little to help convert the
TIMESTAMP to a struct tm or TDateTime (Borland C++)
data type.
Kurt.
The fish are biting.
Get more visitors on your site using Yahoo! Search Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php
That is the issue I'm having that I can't figure
out....
I finally broke down an bought the Firebird Book
(online) and discovered I can CAST the field result to
a CHAR(24), but that does little to help convert the
TIMESTAMP to a struct tm or TDateTime (Borland C++)
data type.
Kurt.
> --- Ivan Prenosil <Ivan.Prenosil@...> wrote:____________________________________________________________________________________
>
> > The double-quoted string is what is returning from
> > the DB.
>
> So you are storing timestamps as CHAR or VARCHAR
> type instead of TIMESTAMP ? Why ?
> And as you noted, quotes are not allowed in string
> representation of timestamp if you expect Firebird
> to do a conversion into timestamp.
>
> Ivan
> http://www.volny.cz/iprenosil/interbase/
>
The fish are biting.
Get more visitors on your site using Yahoo! Search Marketing.
http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php