Re: confused big time

RD> But now() IS a DB friendly format for MySQL and is the recommended RD> way of inserting the current time into a datetime or timestamp RD> field. But what about MsSQL, Oracle and postgres to name a few. I have worked on a few projects where you read from one db and load into another db. Dates then become the spawn of satan. RD> Converting it to a timestamp/datetime locally first is a waste of RD> processing time IMHO and opens you up to a potential RD> slight) True that it wastes CPU time, but in todays climate, having developers churning out manageable , readable code is better then something that looks like the perl DeCSS program. If you need the nano seconds that much buy a better box !. Mark