🚀 go-pugleaf

"Wayne Niddery [TeamB]" <wniddery@chaff.aci.on.ca> wrote in message
news:3deaa602$1@newsgroups.borland.com...
> "Edward Diener" <eddielee@tropicsoft.com> wrote in message
> news:3dea6388$1@newsgroups.borland.com...
> > How does one convert:
> >
> > 1) A 32-bit integer date value to an acceptable SQL value for a DATE
> column,
> > or does a 32-bit numeric value suffice ?
> > 2) A 32-bit integer time value to an acceptable SQL value for a TIME
> column,
> > or does a 32-bit numeric value suffice ?
> > 3) A 64-bit large integer value to an acceptable SQL value for a
TIMESTAMP
> > column, or does the 64 bit numeric value suffice ?
>
> It is impossible to answer this without knowing what the base and format
of
> these 32 / 64 bit values are. Is the 32 bit date a number of days? If so
> what date does a value of 0 equal? Is the Time value a number of seconds,
> milliseconds, ...?

This is all explained in the Data Definition Guide under the topic "DATE,
TIME, and TIMESTAMP datatypes". But I do see a slight mention of conversion
routines which go from the internal type to a C struct and then I recall in
the Embedded SQL guide some info about converting from the C struct to
acceptable SQL formats. I will work my way through all of that and come up
with a solution. Thanks !