How to only store time in visual basic and sql 2008

[WendyT]

Hi everybody,

I wonder how can we store time only in SQL database through Visual Studio 2008? In Visual Studio 2008, when I use datetime, Visual Studio and SQL store the date and time together. However I only want to store time. Thanks for the help.

Wendy

[WingedPanther]

You can store the date portion as 12/31/1899. That allows you to ignore it in the application.

[WendyT]

I have tried this trick, but when I display the data thru dataview, the date still appears there. Help me please somebody....

Wendy Tjan

[WingedPanther]

VB should have a way to change the display format. Since I'm not a VB programmer, I can't offer much more than that.