• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 402
  • Last Modified:

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
0
mickeyshelley1
Asked:
mickeyshelley1
  • 2
1 Solution
 
Lee SavidgeCommented:
getdate()
0
 
PortletPaulfreelancerCommented:
[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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now