Problem with Time Field in Access RRS feed

  • Question




    I'am programming in VB .NET 2005. I've a proper connection with an Access database. In the Access database there is date time field which shows the time. In the database you can see a time for example 10:05:15. This is correct.


    Now I want the to show the time in a datagrid.

    SELECT sTime, Product From tblDelivery


    Then we can see the product properly but the time is 30/12/1899 10:05


    How does this come? How can I let the date disappear?



    Friday, October 3, 2008 8:21 AM

All replies

  • Did you try using the Format function in your Jet SQL statement? The Date data type in Access contains both date and time information.

    Friday, October 3, 2008 1:59 PM