How to pass datetime as parameter to a sql openquery

sql sql-server database openquery
Zvonimir Tokic picture Zvonimir Tokic · Jul 9, 2015 · Viewed 8.2k times · Source

I have an OPENQUERY statement

SELECT * 
FROM OPENQUERY (NETLINE, 
                'SELECT * FROM XCREW.CTNAISV_HOTELCREW where RESERVATION_DATE = ''2015-05-01''')

After executing it I have error message on 2015

How to pass datetime as parameter in OPENQUERY ?

Thanks

Answer

Ionic picture Ionic · Jul 9, 2015

Try this instead. Explicitly convert it to a datetime (maybe convert it to the proper datetime format you use).

SELECT * 
FROM OPENQUERY (NETLINE, 
                'SELECT * FROM XCREW.CTNAISV_HOTELCREW where RESERVATION_DATE = CONVERT(datetime,''2015-05-01'')')

The proper format can also applied using CONVERT(datetime, N'2015-05-01', 112) (for example).

Related questions

Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
How to replace a string in a SQL Server Table Column

I have a table (SQL Sever) which references paths (UNC or otherwise), but now the path is going to change. In the path column, I have many records and I need to change just a portion of the path, but …

Read More