Need help displaying date/time value in VB program

[CraigBest]

Hi folks

Don't know if anyone can help me, but I'm having trouble trying to display a full date/time value coming from an Oracle DB in a Visual Basic .NET 2005 application.

No matter what display mask I try to apply to the data (even no mask at all) all that ever displays is the date part, like this: "6/14/2007". I know that the time data is also there in the field, and what I actually want to display is the time part of the field.

Is there something I can do in the select statement I'm using to pre-format the data so I'll get the time value I'm looking for?

Thanks if you can help.






CraigHartz

 

[stefanhei]

Hi,

You can use the TO_CHAR function to display only the time part:

SELECT TO_CHAR(your_date_filed,'HH24:MI:SS') 
FROM yourtable

Stefan