For example, you have an SQL statement with a date parameter $date_parm. The SQL statement appears as the following expression:

select * from <table_name> where <date_port> > $date_parm

Since the parameter $date_parm is a string, add single quotes to the parameter in the query. The following expression shows the query where single quotes are added to the parameter:

select * from <table_name> where <date_port> > '$date_parm'

If the default value of the parameter $date_parm is

01/31/2000 00:00:00

, the following expression shows how the Data Integration Service expands the query:

select * from <table_name> where <date_port> > '01/31/2000 00:00:00'

You use the same SQL statement with a date parameter $date_parm. The SQL statement appears as the following expression:

select * from <table_name> where <date_port> > $date_parm

You add single quotes to the default value

'01/31/2000 00:00:00'

. The following expression shows the expanded query:

select * from <table_name> where <date_port> > ''01/31/2000 00:00:00''

Since single quotes are part of the default value, the Data Integration Service escapes the data with additional single quotes. Because the string parameter contains double quotes in the expanded query, the query might fail or produce no result.