how i can save a time value, [Archive]

Click to See Complete Forum and Search --> : how i can save a time value,

sam7_976

01-11-2005, 08:28 AM

Dears,
I am prepared a web application (ASP.NET,VB.NET,Sql Server) and i have to save time values in sql server database, i invoked textbox to the form i tried to write time value in it to save in the database, but every one it was generate a run time error (DateTime field overflow),
how do i can save a time value in the database.
Thanks

PeOfEo

01-11-2005, 01:34 PM

You just need to put the date value into the db but do make sure the db's field is using the same dateformat as you are. You can also drop the date into a varchar field, which will still work. What are you be going to doing besides writing the thing back out? Do you need to compare the dates at all.