convert a number to time format

[getnitha]

how to convert a number to time format in vb.net

eg: 8 to 8:00:00

i am storing in sql server number as nvarchar while retreiving in code i need to convert it as 8:00:00 for further calculations

can anyone plse help me

[Plater]

nvarchar can have the type string when read back into your code. Use the Parse and .ToString() property of DateTime to handle this.