How to define a default value for DATETIME column? 2

[sjh]

Hi,

I would like to assign a default value (i.e. current date time) to a DATETIME column in my table. What is the correct syntax for specifying that? In Oracle, I can use SYSDATE, but I don't know if that's possible in SQL Server database.

create table SESSION_INFO (
SESSION_KEY numeric identity,
USERID varchar(32) not null,
STARTED_ON datetime not null
}

Thank you in advance!

 

[jbenson001]

In Sql Server you use getdate(). You can define it in code or you can use Enterpise Manager to set the default.

Jim

 

[SQLDenis]

create table SESSION_INFO (
SESSION_KEY numeric identity,
USERID varchar(32) not null,
STARTED_ON datetime not null default getdate()
)
insert into SESSION_INFO(USERID)
select 1

select * from SESSION_INFO

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Walid]

This will work for sure but Microsoft is recommending against using GETDATE() function and would like to see all programmers use CURRENT_TIMESTAMP.

Walid Magd

The primary challenge of every software development team is to engineer the illusion of simplicity in the face of essential complexity.
-Grady Booch

 

[PWise]

i tried in em to put CURRENT_TIMESTAMP as the default value and it reverts to (getdate())

so much for Microsoft