Is it possible to pass the function GETDATE() as a SqlParameter?

I would like to change:
"UPDATE tablename SET [deleted]=1, [date_modified]=GETDATE(),
[user_modified]=@user WHERE id=@id"

To:
"UPDATE tablename SET [deleted]=1, [date_modified]=@currentdatetime,
[user_modified]=@user WHERE id=@id"

With:
sqlp(1) = New System.Data.SqlClient.SqlParameter("@currentdateti me",
"GETDATE()")

Thanks for the response Ekrem. I had considered that as a solution but I
would like to ensure that date/time is accurate by using the date/time of the
server. I don't have control of all the clients environment so it's possible
for the client date/time to be incorrect or in a different time zone.


"Ekrem Önsoy" wrote:

On Mon, 31 Dec 2007 07:27:01 -0800, Clay wrote:

Hi Clay,

In that case, you have to make sure that GETDATE() (or rather,
CURRENT_TIMESTAMP), runs at the server.

Best way is to create a stored procedure that you call from the client.
Give it an optional paramter and set it to CURRENT_TIMESTAMP if not
filled from the client:

CREATE PROCEDURE MyProc
@TheDate datetime
AS
BEGIN;
IF @TheDate IS NULL
BEGIN;
SET @TheDate = CURRENT_TIMESTAMP;
END;
-- Do something with @TheDate
END;

If you have to send a query string (please don't if you can avoid it!!),
then you can use COALESCE to replace a null value with CURRENT_TIMESTAMP

SET date_modified = COALESCE(@currentdatetime, CURRENT_TIMESTAMP)

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis