I used convert function in sql server with no problem, but when i try to use in in vb6 for my quiry it does not recognize the convert function
rst.open "Select * from mytable where docdate=" & convert(datetime,vDate, 102)
this suppose to filter the rst with docdate= vdate only
note that , docdate(datetime,null)
this gives an error :
Sub or Function not Defined
I am not sure now if the CONVERT function of sql server is supported in VB6
January 17th, 2013, 10:51 AM
Re: sql convert function
If the function is part of your SQL string then it must be part of the sql string. Here you have placed it outside your quotes so VB is looking for a function named convert within your program rather than passing it on as part of the query.
rst.open "Select * from mytable where docdate= convert(datetime, " & vDate &", 102)"