Joining Date & Time

[Strider]

Hey there,

i'm joining a smalldatetime field and a nvarchar field to be a smalldatetime
using the following

 CONVERT(smalldatetime, CONVERT(CHAR(10), dDespatchDate, 111) + ' ' + sSTA)

when i combine a date 02/04/2007 with a string 14:55 it results in 02/04/2007 14:55:00

however when i combine a date 02/04/2007 with a string 00:00 it results in 02/04/2007 with no time attached...

can someone tell me why is this

[si_the_geek]

That's probably just the way it is displayed, I would assume that it actually stores 00:00:00.

If you aren't sure, try a comparison of the two.. eg: the "00:00" one, minus the "14:55" one - should give you something like "31 December 1899 09:05".

[Strider]

yeah i just noticed that i displayed the 00:00:00 inside SQL Management Studio but not inside Visual Studio Server Explorer..

Dam confusing microsoft