Save the date & time

[rupeshkumar_rj]

I am trying to save the date & time into a table in SQL. I am using the datetimepicker control of VB. But, by using this I can save either the date or the time .. not both at a time. How do I store both using a control & in only one column of SQL table.

[brucevde]

Set the DatePicker Format and CustomFormat properties to allow the user to enter date and time.

Private Sub Form_Load()
    With DTPicker1
       .Format = dtpCustom
       .CustomFormat = "dd-MMM-yyyy hh:mm:ss"
       .Value = Now
    End With
End Sub

Private Sub DTPicker1_CloseUp()
    Debug.Print DTPicker1.Value
End Sub

As for saving to SQL, are you updating or inserting? Are you using stored procedures, inline sql statements or recordsets???

[pons]

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

[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.