How do I select time only from a DATETIME column?

[Praveen 123]

sir, I am developing an application in ASP.NET using VB.NET.My backend tool is MS-Access.How can i select time only from a date time feild... Actually i want 09:00:15 AM/PM only...But its displaying 12/12/1987 09:00:15 AM/PM ...

Praveen.K System Engineer Graviton Technologies Pvt.Ltd

[M Hall]

use the format command i.e Format(yourdata, "h:mm:ss")

[Johan Hakkesteegt]

Although VB6's Format still works nicely, you're better off using .net's built in properties, because you can never be sure about the settings of client PCs and servers, etc: Depending on what exactly you need you can use: YourDate.ToLongTimeString or YourDate.ToShortTimeString Johan

My advice is free, and you may get what you paid for.