On Fri, Oct 18, 2002 at 07:23:29 -0400, [EMAIL PROTECTED] wrote: > Bhuvan A ([EMAIL PROTECTED]) reports a bug with a severity of 2 > The lower the number the more severe it is. > > Short Description > now() in transaction > > Long Description > I am using 7.2.1. now() returns same value ever, within transaction. If we use now() >say 10 times in the same transaction, all 10 times we are getting the same value, >irrespect of the interval. 7.2 too behaves similar.
This is how it is supposed to work. If you need the current time, rather than transaction start time, use timeofday(). This is covered in the documentation. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
