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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I tried getdate() but it timed out...
ASKER
Your answer worked after i first saved the new field then cam back and modified it with the default value...Thank you very much
but I'm not familiar with that input form so I don't know what is expects/allows