Dim command As New SqlCommand("INSERT into EmployeeDetails(AddedOn)Values(@AddedOn)")
command.Parameters.AddWithValue("@AddedOn", Date.Today)
NB: If your column type is defined as
datetime
or
datetime2
, this will store the date with a time of
00:00:00
. If you want to store the date
without any time information, then change your column type to
date
.
Date and time types | Microsoft Docs[
^]