What errors are you getting? Here is an example of taking the time, adding a minute and inserting it into a table called testschedule...
CODE
CREATE PROCEDURE [dbo].[addscheduledate] AS
-- Declare our variable as a datetime
DECLARE @RealDate datetime
BEGIN
-- Set NOCOUNT on and then select the date, adding 1 minute
SET NOCOUNT ON;
SET @RealDate = (SELECT DATEADD(minute,1, {fn NOW()}) )
-- Now take that variable and put it into an INSERT statement into the table.
-- Here "thedate" represents a datetime column.
INSERT INTO testschedule (thedate) VALUES (@RealDate)
END
GO
We create a datetime variable, take the current time and add 1 minute, then insert it into our table called testschedule. The column "thedate" is of type datetime and notice we insert it in.
Make sure that if your column InmID is the primary key and set as identity to autoincrement that you DO NOT include it in the insert query.
Hope this works out for you. Enjoy!
"At DIC we be TSQL kicking code ninjas... we also kick ASP, TNA, RPG, NWA, and OMFGLOL!"
25 Aug, 2008 - 07:17 PM
| 