the datetime or timestamp for parameterized macro not working( no error though)

[subbu_uppuluri]

Can anyone please help. I am trying to use the datetime or timestamp for parameterized macro in report studio query (direct query in native sql) is not working. It is not giving error at the same time when i enter datetime in the prompt page, the page freezes. But for date only is working.

Thank you for your help in advance.

Subbu.

between to_date(#sq(prompt('start','DATETIME'))#,'YYYY-MM-DD HH:MM')
                  AND to_date(#sq(prompt('end','DATETIME'))#,'YYYY-MM-DD HH:MM')
             )

OR

between to_date(#sq(prompt('start','TIMESTAMP'))#,'YYYY-MM-DD HH:MM')
                  AND to_date(#sq(prompt('end','TIMESTAMP'))#,'YYYY-MM-DD HH:MM')
             )