[Info-Ingres] ansidate('now')

[Martin Bowes]

Hi Everyone,

 

What is the ansidate equivalent of 'now'?

 

I'm trying to store data in a table and I need the time of storage to be
as unique as possible. The nanosecond capacity of ansidate seemed to be
the way to go. But I cant create an andsidate column with default 'now'.

 

Furthermore, the only thing I have found is: select
timestamp_local(date('now'))\g

Trouble is, the ingresdate 'now' has no sub second capacity, and so the
returned time always has seconds.000000000.

 

The table in question has been in existence for a long time and the
applications around it have already been built so I need something that
can be retro-fitted transparently if possible.

 

Martin Bowes

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20080409/8e84343c/attachment.html