Save the date & time

[leinad31]

assuming that you are using an update query to perform this

strDate=Format(dtDate.value,"dd-MMM-yyyy" )
strTime = dttime.value


"update table set datetimecolumn = '"& strDate & " " & strTime &"' where " 'conditions here

OR

you can set the property of the datetime picker control
to opt for
format as 3 -dtpCustom
and change the custom format text as dd-MMM-yyyy hh:mm:ss tt

now you can have the date time in a same control

The query would depend on the database, and the data type of destination field.