[thelist] CF Timestamp in a hidden input
Scott Dexter
sgd at ti3.com
Wed Jul 19 19:42:13 CDT 2000
> -----Original Message-----
> > obviously, the reserved word "current date" will vary from
> database to
> > database, so you gotta look it up
> >
> > in ms access, it's Date()
> >
> > also, you may be off by a few seconds in a timestamp if what you're
> > capturing is a user event, but in one sense, using the
> > database's timestamp
> > is better, because the event didn't happen unless/until it's
> > logged in the
> > database
in MS SQL Server, its a function: GetDate()
and on the second point, we use the db server's timestamp exclusively, comes
in handy when you have multiple machines running different kinds of software
read/writing to the db. On top of that we have this little handy-dandy
utility called AboutTime which syncs up the machine's clock with the udp
time protocol --it even accounts for latency in the network (can't remember
if the program or the protocol does the compensation).
<wrap>
http://www.arachnoid.com/abouttime/index.html
</wrap>
sgd
--
think safely
More information about the thelist
mailing list