If you are using MS SQL, then GetDate() returns the date and time on a
server. I fact, you can automate this process, but creating a field with
the default value of GetDate().
Dennis.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Cheng Wei
> Sent: Tuesday, 8 February 2000 12:26
> To: Multiple recipients of list delphi
> Subject: [DUG]: Server time
>
>
> Hi all,
>
> I'm currently developing a time recording app to be used in
> the factory
> environment, the DB resides in a central server with several
> workstations
> connect to it. The workers record their activities via the
> workstations.
> Some of the job items are budgeted and budgeted time can be
> as less as 5
> minutes, therefore the accuracy of time records are significant.
>
> Because the time settings are usually vary from wkstation to
> wkstation, so
> if someone started a job item from one machine and then claim it from
> another, the duration (the different between timestamp value) won't be
> accurate.
>
> I think the solution would be to use the server time for all.
> Could anyone
> help me on how to get timestamp from server? or any other suggestions?
>
> Thanks
>
> Cheng
>
> --------------------------------------------------------------
> -------------
> New Zealand Delphi Users group - Delphi List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
