I am wondering if someone can help on the following issue, I have a sql database in table containing three nvarchar variables, the reason i am using nvarchar is because the server instance i am using is sql server 2000 which has no separate field for date and time, so I stick to use nvarchar to input the:
Sign in Time
Now I need two more columns that need to calculate
Wait Time = Reg Start - Sign In Time
Total Registration time = Reg End - Re Start
As you can see the issue relies on the data types, is there a workaround to this?
Can I Convert the data types on the asp.net code page to a time column and perform the substractions?
Meabe in Sql server?
Ultimate the goal is to self auto-compute this columns so I can represent in a asp.net GridView
Please advise, thanks in advance