Sql Params and getDate()

[strider]

Hey there,
when using a parameterised insertion sql statement has can you specify it to use sqlce getDate function to insert a date into a datetime field


insertCommand.Parameters.Add(New SqlServerCe.SqlParameter("UnitOutDate", SqlDbType.DateTime))
insertCommand.Parameters("UnitOutDate").Value = Date.Now

Im using Date.Now but i want to use SQL's getDate function so as regional settings wont matter

how can i specify to use the sql getDate function???

 

[jvencl]

You can move this function out of your code and into a Store Procedure on the server. Then just use the GetDate function with the StoreProc.

 

[TechGnome]

Or just use GetDate() instead of the parameter, right in the SQL.

-tg

 

[strider]

you cannot create stored procedures on sql server ce

 

[TechGnome]

Buuut, you should still be able to use GetDate() right in the SQL sans Parameter.

-tg

 

[strider]

ya i know i can use it as "INSERT INTO mytable (mydate) VALUES (getDate())"

but i need to use paramets as the .prepare statement will filter out errors and
also use parameters is more efficient