Vista - select from database and own parameter

Hi,
I've huge problem with one thing. I need to create select in oracle
where one comparison will include my own parameter.
Here is example:

sql = "select to_char(oradatetime,'rrrr-mm-dd HH24:MI:SS') oratime
from table where oratime >= MYPARAMETER"


MYPARAMETER is date type - conversion the same like oradatetime
MYPARAMETER = date & " " & time

MyStrDate = CStr(MYPARAMETER )

If I use:
sql = "select to_char(oradatetime,'rrrr/mm/dd HH24:MI:SS') oratime
from table where oratime >= " & MyStrDate

I got error that:
Microsoft OLE DB
Provider for ODBC Drivers: [Microsoft][ODBC driver for Oracle][Oracle]
ORA-00933
: SQL command not properly ended

Does anybody know how to avoid this error
I've tried join, replace, chr(34) - nothing work when I try to use sql
connection I got this error.

Regards,
esska

esska wrote:Do you mean:
MYPARAMETER = Now()
?Use a parameter token:

sql = "select to_char(oradatetime,'rrrr/mm/dd HH24:MI:SS') " & _
"oratime from table where oratime >= ?"

Use a command object to pass the value into the statement:

set cmd=createobject("adodb.command")
cmd.commandtype=1 '1=adCmdText
cmd.commandtext=sql
set cmd.activeconnection = yourcommandobject
set rs = cmd.execute(,CDate(MYPARAMETER))


--
Microsoft MVP - ASP/ASP.NET - 2004-2007
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

The error message you're getting says that your SQL command isn't
properly ended.

That means you need single quotes around the date.

sql = "select to_char(oradatetime,'rrrr/mm/dd HH24:MI:SS') oratime
from table where oratime >= '" & MyStrDate & "'"

Hi,
Thank you for replying.

The problem was with sql, it shoud be something like this:

sql = "select to_char(oradatetime,'rrrr/mm/dd HH24:MI:SS') from table
where oradatetime>= (' " & MyStrDate & "','rrrr/mm/dd HH24:MI:SS')".

I use this to execute command: oRs.open sql, oConn
which is similar to executhing made by Bob.

Thank you for help.

Regards,
esska