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

Now()

Status
Not open for further replies.
eggy168

eggy168

Programmer
Mar 6, 2002
220
US
Hi, I am wondering is SQL Server 2000 has this Access function for the Datetime datatype? If so, how can I set it?
Thanks
 
Sort by date Sort by votes
I believe you are looking for Getdate() it comes off the system date/time of the computer. So set your computer clock to the time you want.
 
Upvote 0 Downvote
Yes, this is exactly what I am looking for. Thank You so much!!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JohnBates
  • Locked
  • Question
Moved App from PC to Server - Now How to Run App from PC? 1
Replies
1
Views
26
mrdenny
mrdenny
n2jesus
  • Locked
  • Question
I NEED HELP NOW!!!
Replies
2
Views
31
mrdenny
mrdenny
jmille34
  • Locked
  • Question
changed subscriber to publisher, now double constraints
Replies
3
Views
46
jmille34
jmille34
snootalope
  • Locked
  • Question
Broken Mirror - now what?
Replies
0
Views
31
snootalope
snootalope
NuJoizey
  • Locked
  • Question
Moved DB, now Users can't login to my web app. 1
Replies
2
Views
38
NuJoizey
NuJoizey

Part and Inventory Search

Sponsor

Back
Top