Re: Inserting Calendar.Time in a database

[402450@cepsz.unizar.es (Jano)]

Duncan Sands <baldrick@free.fr> wrote in message news:<mailman.3.1091792465.414.comp.lang.ada@ada-france.org>...
> If you are using GNAT, have a look at GNAT.Calendar
> and GNAT.Calendar.Time_IO.

Pardon me as I see I've not exposed some of my requirements. The
timestamp column is used in other SQL queries, and that column to be
indexed is extremely interesting. Because of that, I can't afford to
transform a string representation or 'seconds-after-epoch' since the
index is lost. My database doesn't allow neither to index a view, so
that's why the trigger solution is for now the more appealing. Unless,
of course, there is a way to insert timestamps with Gnade.

I suppose that if I use the thin binding, knowing the internal
representation of a sql timestamp as required by the ODBC interface
would be enough.