>I'm astonished; I'd expect data bases to log times of transactions. Or is that left the responsibility of the UI/API?
Gil, When I say DB2 gives a static timestamp is when you are trying to get EXISTING records from a DB2 table and append a time stamp. Something like this SELECT NAME ,CURRENT TIMESTAMP FROM SYSIBM.SYSTABLES ; Thanks, Kolusu DFSORT Development IBM Corporation ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN