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!

getdate

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Why i can change the current system date and time in the Microsoft® SQL Server™ standard internal, because when i use the function getdate the system return 22 jan 2040, but we are in 2002

Please help me
 
Sort by date Sort by votes
SQL Server takes the date from the machine it's running on. You need to change on the PC via the contraol panel.

Rick.
 
Upvote 0 Downvote
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top