hm, how about this if thats the case:
insert into thing (id, dateandtime) values (1,'now');
(where dateandtime is a 'date' field)
works for me, most of the time :)
N
----- Original Message -----
From: "Nahum Wild" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Tuesday, February 08, 2000 1:33 PM
Subject: RE: [DUG]: Server time
> What db are you using? If its interbase then you could write a stored
> procedure or trigger that automaticlly inserts the date whenever a record
is
> written. Since this is all performed on the server then all transactions
> from all clients would use the servers time.
>
> I persume that you could do this kind of thing with other DB but interbase
> is the only CS DB I have experience with.
>
>
> Nahum
>
> -----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
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
