factory function that returns the same for an entire transaction

hi
I'm working on a Factory function ( NOWPLUS(int) ) which is supposed to
return a timestamp which is Now+XXXsec. I need the timestamp to be the
same for an entire transaction, so if I insert 2000 rows,

INSERT INTO table (vDate, vInfo) VALUES
(NOWPLUS(1000),'info1'),(NOWPLUS(1000),'info2'),...(NOWPLUS(1000),'info
2000 ');

then the "now" part of the timestamp should be the same for all (ofcause
the sec offset should be changeable)

Does anyone have an idea on how to do this? It is no problem that I need
to change the main system because it is allready modified in other
places. 



-- 
   Kim Schulz   | Keen of Fundanemt? Want to share experieces with 
 Geek by nature | other users? join The Fundanemt User Group NOW!    
   schulz.dk    | http://www.fundausers.org    


-- 
   Kim Schulz   | Want to know more about The Fundanemt CMS. Join the
 Geek by nature | users and developers at linuxforum 2005.
   schulz.dk    | http://www.linuxforum.dk


---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (GNU/Linux)

iD8DBQFCOTivGL7stJdXdNIRAgxeAJ0YmySPk+iIPPn8AzPAesNrVn9XngCggP95
FzpFDGgieRRhrIMteAEI2tU=
=+Qsf
-----END PGP SIGNATURE-----