sql server - How to pass datetime as parameter to a sql openquery -

i have openquery statement

select *  openquery (netline,                  'select * xcrew.ctnaisv_hotelcrew reservation_date = ''2015-05-01''') 

after executing have error message on 2015

how pass datetime parameter in openquery ?

thanks

try instead. explicitly convert datetime (maybe convert proper datetime format use).

select *  openquery (netline,                  'select * xcrew.ctnaisv_hotelcrew reservation_date = convert(datetime,''2015-05-01'')') 

the proper format can applied using convert(datetime, n'2015-05-01', 112) (for example).