Date and time Concatenation

Hello,

I have 2 columns in a table, one with date ("M/DD/YYYY" format) one with time ("HH:MM" format)

How can i do to make one date column in "DD/MM/YYYY HH:MM:SS" format ?

Thanks a lotHave a look here: http://blogs.conchango.com/jamiethomson/archive/2005/07/26/1867.aspx

-Jamie