With Informix there are date time identifiers such as "Today" or "current,
which can be used in sql statements. This uses the date/time of the server.
eg
update time_table
set time = current year to minute
If you db has this that could be your answer.
> -----Original Message-----
> From: Cheng Wei [mailto:[EMAIL PROTECTED]]
> 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
