Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Default Date in SQL		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Cliff
Average Member

United States
501 Posts
Posted - 16 July 2004 :  07:21:11  Show Profile  Visit Cliff's Homepage
How do I set a default date in a SQL 2000 table?

When the table was in Access I used Now() as the default. I don't want the table to have no value, and I can't set it in the page. Is this possible in SQL?

Thanks
https://squarewheelscycling.com/

https://www.pathlabtalk.com/

pdrg
Support Moderator

United Kingdom
2897 Posts
Posted - 16 July 2004 :  07:27:00  Show Profile  Send pdrg a Yahoo! Message
getdate()
Go to Top of Page

Cliff
Average Member

United States
501 Posts
Posted - 16 July 2004 :  07:55:43  Show Profile  Visit Cliff's Homepage
Wow, you guys are too much. 6 minutes for the response!!

pdrg, this worked great and solved a big problem, thank you very much!
https://squarewheelscycling.com/

https://www.pathlabtalk.com/
Go to Top of Page

pdrg
Support Moderator

United Kingdom
2897 Posts
Posted - 19 July 2004 :  07:17:03  Show Profile  Send pdrg a Yahoo! Message
we aim to please :) Promise to get it under 5 mins next time ;-)
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.29 seconds. Powered By: Snitz Forums 2000 Version 3.4.07