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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

setting system date

Status
Not open for further replies.
msalvador

msalvador

Programmer
Nov 13, 2001
33
0
0
IT
hi, there is a function to set system date
 
Sort by date Sort by votes
I dunno but I think you'd have to hit windows API for that. JHall
 
Upvote 0 Downvote

I would recommend controlling the system date form the NT server rather than trying to set it from SQL Server.

You can install a time program that will synch the NT system date/time with time servers available on the internet. Dimension 4 and About Time are free and I've used boith to keep servers and PCs set to the correct time. You could also set up a Time server on your LAN and synch to that via NET TIME.

I suppose you can use xp_cmdshell to set the date/time.

xp_cmdshell 'date 2/8/02'
xp_cmdshell 'time '12:21' Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How te filter by date ?
Replies
9
Views
119
dhookom
dhookom
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
120
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
70
Andrzejek
Andrzejek
niall5098
  • Locked
  • Question
Create plan guide with date time parameters
Replies
3
Views
67
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
How to get monther per part id from last date to current date and include remaining date ? 1
Replies
7
Views
102
JohnBayne
JohnBayne

Part and Inventory Search

Sponsor

Back
Top