Solved

Setting default datetime in MSSQL Enterprise Manager

Posted on 2006-06-21
2
371 Views
Last Modified: 2013-12-03
I have a datetime field in MSSQL.  I am using Enterprise Manager.  I would like to enter a default value for this field.  I try to enter (now())  or now()  or isNow()  but it will not take it.  How do I do it?
0
Comment
Question by:JuniorBee
2 Comments
 
LVL 20

Accepted Solution

by:
Sirees earned 350 total points
ID: 16955538
Instead use getdate()
0
 
LVL 27

Assisted Solution

by:ptjcb
ptjcb earned 150 total points
ID: 16955588
Yes, SQL Server does not have  a NOW function. Sirees is right - use GETDATE() or CURRENT_TIMESTAMP - they are the same thing. If you need UTC the GETUTCDATE() will give you that.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

895 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

14 Experts available now in Live!

Get 1:1 Help Now