sql 字符连接问题?

Question

Start Date > '23/9/2006' '12:20:45'
  我想用上面的条件,,怎样才能把'23/9/2006'和'12:20:45'连接起来为已个条件为
    '23/9/2006 12:20:45'给Start Date 谢谢咯

Answer 1

convert (datetime ,    '23/9/2006'+' 12:20:45')

Answer 2

select convert (datetime ,right( '23/9/2006',4) +'-0'+substring('23/9/2006',4,1)+'-'+left('23/9/2006',2) +' 12:20:45')

Answer 3

convert(datetime,'23/9/2006'+' 12:20:45',103)

Answer 4

xiaoku(小苦走了,小酷来了!) 加个103就好了  ^0^