Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 DateTime

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2007-02-12 : 17:42:57
Hello,

I have a table for statistics where one of the columns is the DateTime when the record was added.

In this moment I am sending the DateTime from my .NET code as a procedure parameter.

Should I instead generate it in my SQL procedure code?

How can I get the current Date and Time in my SQL stored procedure?

Thanks,
Miguel

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-12 : 17:57:14
getdate()


KH

Go to Top of Page
   

- Advertisement -