Date and time

Hi All,

SAP Stores its document date and time in separate fields and I need to combine into a proper datetime format using a simple SQL query:

Select docdate, doctime from oinv shows:

docdate doctime

2011-12-02 00:00:00.000 1630

2012-02-09 00:00:00.000 943

Should show in proper datetime format:

2011-12-02 16:30:00.000

2012-02-09 09:43:00.000

Does anyone have SQL code for this?

Regards

Aubrey