Hi,
I have a problem in my code and here is the description:
I use VB.Net 2008 Pro + SQL server 2005 Express.

I have a table that contain few date field and i use the local dates & time values to save it in the database using simple SQL code.

Here is what working for me and what not working for me:
OK:
[ScanDate] '11/10/2009'
[ScanTime] '8:51 AM'
[TimeStamp] '11/10/2009 8:51:05 AM'

Not OK:
[Date] '30/10/2007'
[ScanDate] '11/10/2009'
[ScanTime] '8:55'
[TimeStamp] '11/10/2009 8:55:14'

I guess it becuase the time missing the AM\PM but is there any way that i can convert: 8:55 to 8:55 AM?
Thanks