Re: [Info-Ingres] Getting precise values for TIMESTAMP(n) columns

Hi Roy,
There is the function CURRENT_TIMESTAMP that may be what you are looking
for.
Regards,
Ian

-----Original Message-----
From: info-ingres-bounces-at-kettleriverconsulting.com
[mailto:info-ingres-bounces-at-kettleriverconsulting.com] On Behalf Of Roy
Hann
Sent: 14 October 2008 11:26
To: info-ingres-at-kettleriverconsulting.com
Subject: Re: [Info-Ingres] Getting precise values for TIMESTAMP(n)
columns

Roy Hann wrote:

> I have been trying to find a way to get Ingres to supply a timestamp
> with millisecond precision (and accuracy) to store in a TIMESTAMP(3)
> column in a database procedure. So far I've come up empty-handed.
> Anyone got any suggestions?

One of my colleagues who hadn't even seen this just phoned me out of the
blue to tell me that a TIMESTAMP column WITH DEFAULT will be given the
current time when you insert a row. That's a good start, although I
will have to hold my nose if I am going to rely on a default value when
inserting.

Now, what can I do about timestamps for updates?

--
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9,
2009
Go to http://www.iua.org.uk/join to get on the mailing list.


_______________________________________________
Info-Ingres mailing list
Info-Ingres-at-kettleriverconsulting.com
http://www.kettleriverconsulting.com...fo/info-ingres

Ian Kirkham wrote:

> Hi Roy,
> There is the function CURRENT_TIMESTAMP that may be what you are looking
> for.

Excellent. (Silly me for thinking I'd find it in the index of the SQL
Reference Manual.)

That's just what I needed. Thanks.

--
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to http://www.iua.org.uk/join to get on the mailing list.