Re: Inserting Calendar.Time in a database

["John B. Matthews" <nospam@nospam.com>]

In article <opsci5bhcgp4pfvb@bram-2>,
 "Nick Roberts" <nick.roberts@acm.org> wrote:

> On Tue, 10 Aug 2004 08:36:44 GMT, John B. Matthews <nospam@nospam.com>  
> wrote:
> [...]
> > Does the OP's database support conversion with a format mask?
> > For example, assuming a fuction that converts a Time to a
> > formatted String, tell the database what format to use:
> >
> > DT_String := To_String(Clock);
> > ...
> > insert into <table> values
> > (..., TO_DATE(:DT_String,'YYYY-MM-DD hh:mi:ss'), ...);
> >
> > I understand this is non-portable.
> 
> Couldn't one simply use:
> 
>     insert into <table> values
>        (..., Current_Timestamp, ...)
> ?

Indeed, the ODBC driver's function Current_Timestamp would 
insert the current server-side timestamp. Unfortunately, the 
server and client may be in different timezones, leading to 
Dmitry's original observation about political v. universal time.

Also, the OP wanted to know the ODBC driver's vendor-specific 
timestamp literal format. It's often something like

{ts 'yyyy-mm-dd hh:mi:ss'}

John
----
jmatthews at wright dot edu
www dot wright dot edu/~john.matthews/