none
Problem with Time Field in Access RRS feed

  • Question

  •  

    Hello,

     

    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?

     

    Thanks

    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