Date as a parameter

vsi · Post by **vsi** » Wed Jun 14, 2006 1:26 pm

Hi,

Can we use date as a parameter to the SQL queries which we embed in Database Stages to extract data??

Thank You

kris007 · Post by **kris007** » Wed Jun 14, 2006 1:28 pm

Yes, you can.

nick.bond · Post by **nick.bond** » Wed Jun 14, 2006 10:01 pm

Yes - just remember that the parameter is inserted into the SQL statement exactly as it is written and no quotes are put in there for you, so if the parameter contains a string value you will need single quotes around it.

e.g.

select * from my_table where my_varchar_col = '#pMY_PARM#'

DSguru2B · Post by **DSguru2B** » Thu Jun 15, 2006 6:57 am

Also keep in mind that you should send a date part and a time part seperately, or timestamp with only integers in it. Because unix doesn like space in the param file and in a timestamp you will have a space between a date and time part.