Link to home
Start Free TrialLog in
Avatar of mickeyshelley1
mickeyshelley1Flag for United States of America

asked on

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

User generated image
Avatar of Lee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
[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
Avatar of mickeyshelley1


I tried getdate() but it timed out...
Your answer worked after i first saved the new field then cam back and modified it with the default value...Thank you very much