How Do I Set The Default Value Of Date Time In SQL

I am using Microsoft Sql Server Manage Studio Express  C to create another field to store the date that an entry is made, I have been trying to use now() like i used to to in Access but it didn't like it, so what do i do the get the long date format of mm,dd,yyyy HH:nn? or something close

MgmtStudioExp
mickeyshelley1Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Lee SavidgeConnect With a Mentor Commented:
getdate()
0
 
PortletPaulCommented:
[in sql server] getdate() is the equivalent to now()

but I'm not familiar with that input form so I don't know what is expects/allows
0
 
mickeyshelley1Author Commented:
I tried getdate() but it timed out...
0
 
mickeyshelley1Author Commented:
Your answer worked after i first saved the new field then cam back and modified it with the default value...Thank you very much
0
All Courses

From novice to tech pro — start learning today.