how to query my sql database by using date variable
hi,
when i was trying to query the record in my sql by using a date variable, nothing i can get. this is due to the syntax "" problem.
the query i used in my sql work but not in soapui.
would you mind helping on it?
workable sql in my sql
SELECT * FROM `events` e where timestamp = "2011-01-18 05:00:02";
failed sql I used in soapui:
SELECT * FROM events where timestamp = '${groovy#result}'
SELECT * FROM events where timestamp = "'${groovy#result}'"
when i was trying to query the record in my sql by using a date variable, nothing i can get. this is due to the syntax "" problem.
the query i used in my sql work but not in soapui.
would you mind helping on it?
workable sql in my sql
SELECT * FROM `events` e where timestamp = "2011-01-18 05:00:02";
failed sql I used in soapui:
SELECT * FROM events where timestamp = '${groovy#result}'
SELECT * FROM events where timestamp = "'${groovy#result}'"