Thread: is current_timestamp unique for a transaction?

Is current_timestamp(6) garunteed to be unique for each transaction?

--
Alan Gutierrez - ajglist@izzy.net

On Sat, Feb 15, 2003 at 21:49:34 -0600,
  Alan Gutierrez <ajglist@izzy.net> wrote:
>
> Is current_timestamp(6) garunteed to be unique for each transaction?

No.

If you want guarenteed uniqueness use a sequence.

Not guaranteed, but also not likely to be the same value unless you have
high volume.

Use a sequence if you need a unique number.

On Sat, 2003-02-15 at 22:49, Alan Gutierrez wrote:
> Is current_timestamp(6) garunteed to be unique for each transaction?
--
Rod Taylor <rbt@rbt.ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

On Sunday 16 February 2003 09:19 am, Alan Gutierrez wrote:
> Is current_timestamp(6) garunteed to be unique for each transaction?


Did you mean to ask if value of current_timestamp(6) remains same within a transaction?

if so answer is yes.



--

Regds
Mallah

----------------------------------------
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.