c# - Cast string to date and change year 0001 to 1900 -

i receive string following value:

0001-01-01t12:30:00

i need time portion when saving database.

but can't save 0001 year in mssql server (field smalldatetime type) requires 1900+.

currently check year , recreate date using following code:

... datetime = convert.todatetime("0001-01-01t12:30:00"); datetime d = new datetime(1900, 1, 1, i.hour, i.minute, i.seconds);

is there easier way use date format year set 0001?

i don't know of fields i'm importing might have value , don't want add code of fields.

you can use datetime.add() method in conjunction datetime.timeofday property.

if regular sql datetime use sqldatetime.minvalue helper, , add datetime it.

sqldatetime.minvalue.value.add(convert.todatetime("0001-01-01t12:30:00").timeofday)

for smalldatetime can create own.

new datetime(1900, 1, 1).add(convert.todatetime("0001-01-01t12:30:00").timeofday)

Code wiki