strider
Well-known member
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???
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???