Correct way of storing a date?

[Tarun Mistry]

Hi, i am trying to store a users date of birth, within my application i will
store it as a datetime object, however what is the best way to store it in
the database (SQL SERVER)?

Thanks for any help!
Regards
Taz

 

[Oytun Yilmaz]

You can use a datetime column, and use SqlDataParameter in your insert command

 

[Tarun Mistry]

Hi, thanks for your reply.

Icannot find this method on msdn, could you elaborate slightly?

Kind regards
Taz

 

[Oytun Yilmaz]

SqlCommand command = new SqlCommand("INSERT INTO Table(dateColumn) values(@dateColumn)");
SqlParameter parameter = new SqlParameter("@dateColumn", SqlDbType.DateTime);
parameter.Value = DateTime.Now;
command.Parameters.Add(parameter);

 

[Tarun Mistry]

Many thanks!

Appreciate your help,
Regards

SqlCommand command = new SqlCommand("INSERT INTO Table(dateColumn)
values(@dateColumn)");
SqlParameter parameter = new SqlParameter("@dateColumn",
SqlDbType.DateTime);
parameter.Value = DateTime.Now;
command.Parameters.Add(parameter);