Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date and time stamp

Status
Not open for further replies.
gjgcpa

gjgcpa

Technical User
Sep 21, 2001
3
US
This seems like a simple question, but I can't find an answer anywhere to this point. Our app uses a vb front end with a SQL Seerver 2000 db.

The app date and time stamps all data entry and data changes made by all users. Right now it uses the workstation's date and time. I would like it to use the SERVER'S date and time. This will insure that, even if the server is not entirely accurate, at least all the data will be accurate relative to all the other data, instead of each workstation being out of sync with each other.

Has anyone (or everyone) already done this?

Thanks for your input.
 
Sort by date Sort by votes

Yes, you can use the GetDate() function of SQL Server to do what you want.

Good Luck

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sal21
  • Locked
  • Question
SORT DATE in msflexgrid not correct
Replies
4
Views
332
sal21
sal21
Swi
  • Locked
  • Question
Date/Time Conversion 1
Replies
2
Views
343
Swi
Swi
2009luca
  • Locked
  • Question
GET date from classname
Replies
2
Views
523
2009luca
2009luca
sal21
  • Locked
  • Question
loopimg link and downlosd zip file 1
Replies
3
Views
368
strongm
strongm
2009luca
  • Locked
  • Question
population of italy live/real time
Replies
11
Views
759
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top