c# - SQL SAVE DATATIME -

c# - SQL SAVE DATATIME -

this question has reply here:

insert, select , update datetime 2 answers

i have table date type. , want insert date in format: dd-mm-yyyy (ex: 27/10/2014). tried string problem when want search 2 dates sql compare days. realy need day, month , year. , in c# utilize datetime.now.toshortdatestring(); retrieve date , insert in database.

i used query search dates:

query:

select * [table] ([column] >= '25/10/2014' , [column] <= '26/10/2014');

its way save info format want? more easy select info want.

sorry english, please help thanks.

never ever save date , datetime values strings. , parameterize sql. if want create easy yourself, utilize micro-orm dapper simplify such operations:

var result = connection.query( "select * illustration info between @lower , @upper", new { lower = datetime.parse("10/25/14"), upper = datetime.parse("10/26/14") });

i recommend utilize concrete info types o homecoming info database, not forced utilize dynamic properties.

c# sql-server