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!

simple, what the default column value for datetime

Status
Not open for further replies.
tester321

tester321

Programmer
Mar 13, 2007
150
CA
oh boy, sometime the simplest things i can't remember... is it date() or now() or....

I need to specify a default value for data type datetime for sql2k

Thanks
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
270
bharons
bharons
coorsman
  • Locked
  • Question
Column Data Type. 2
Replies
9
Views
354
Chris Miller
Chris Miller
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
678
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
326
Andrzejek
Andrzejek
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
375
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top