Set Locale of a SQL Server 2005

Dim dc As New SqlCommand("INSERT INTO hello VALUES (@Date)", cn)
dc.Parameters.Add(New SqlParameter("Date", System.DateTime.Now))

INSERT INTO hello VALUES convert(datetime, @Date + ' 00:00:00', 103)

INSERT INTO hello VALUES convert(datetime, @Date, 103)

SELECT myColumn FROM myTable WHERE myDateField >= convert(datetime, @Date + '00:00:00', 103)