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
 General SQL Server Forums
 New to SQL Server Programming
 please help me

Author  Topic 

ramu143
Yak Posting Veteran

64 Posts

Posted - 2008-09-26 : 07:13:50
how to declare sysdatevariable i need to use that one in my procedure sysdate-1 please send me a declaration

jimf
Master Smack Fu Yak Hacker

2875 Posts

Posted - 2008-09-26 : 07:15:33
DECLARE @date datetime
SET @date = getdate()
SET @date = current_timestamp

Jim
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 07:15:39
just use GETDATE() to get system date value.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-26 : 07:17:00
Go to Top of Page
   

- Advertisement -