Solved

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

Posted on 2013-05-10
4
353 Views
Last Modified: 2013-05-10
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
Comment
Question by:mickeyshelley1
  • 2
4 Comments
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 500 total points
ID: 39155853
getdate()
0
 
LVL 48

Expert Comment

by:PortletPaul
ID: 39155854
[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
 

Author Comment

by:mickeyshelley1
ID: 39155923
I tried getdate() but it timed out...
0
 

Author Closing Comment

by:mickeyshelley1
ID: 39156014
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

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now