I'd like to take values between a date range and enter into a table

I have a date range @startdate and @enddate

i'd like my user to enter the date range and then for the system to take the date range entered and insert them into a table, however, my table only allows one date value i.e Dte

how do I take my @startdate and @enddate and make into @Dte?

Is that possible?

INSERT INTO tblA (dte,intID,RoomType,Qty,Price) VALUES (@dte,@ResortID,@RoomType,@Qty,@Price)

Any sort of advise or links would be appreciated

You could take timespan object by subtracting start date from end date. Now you would have "a single datetime value". But if you need to get back either start date or the end date from the timespan, you can't do it. In that case the only solution is to add another datefield to DB which shouldn't be hard.


Can't add a new datefield in db as I do not know what all places in code "select * from table" is being called but I'll try subtracting and see how that goes

Thanks for the heads up!

This question has already been answered. Start a new discussion instead.