What is the Oracle code for converting the format of a date variable?

Hello,

I am trying convert my SQL code into its Oracle equivalent. One part of the original code involves taking the value in a cell, which is today's date, and converting it into the appropriate format within a variable.

Below is an example of the code.

With Selection.ListObject.QueryTable
    .Connection = Conn
    .CommandText = Array(comstring)
    .CommandText = .CommandText + " WHERE (TRAD In ('LSWL'))"
    .CommandText = .CommandText + " AND (INPUTDATE={ts '" & opicsdate & "'})"
    .CommandText = .CommandText + " AND (DETAILIND not In ('FXTR'))"
    .Refresh BackgroundQuery:=False
End With

If I wish to convert into Oracle then I have been informed I would need to change the date line as shown below. I would need to manually type in the relevant date.

.CommandText = .CommandText + " AND (INPUTDATE=to_date('2015/09/03 00:00:00','YYYY/MM/DD HH24:MI:SS'))"

What I would like to do is still be able to keep that opicsdate variable. Is that possible?

Thanks.