Problem with using SQL statement as parameter

collabxchange · Post by **collabxchange** » Mon Sep 08, 2014 3:35 pm

Hi all,

I'm trying to parametrize part of an SQL statement from a query in a SQL Server stage.

CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(), 120) + ' 5:00') - 1

The error I'm getting is saying that ' 5:00' is an invalid argument.

I've tried double quotes and using single quotes around the entire SQL statement. Any ideas?

Thanks guys.

chulett · Post by **chulett** » Mon Sep 08, 2014 3:52 pm

http://www-304.ibm.com/support/docview. ... wg21386517

collabxchange · Post by **collabxchange** » Mon Sep 08, 2014 5:25 pm

Thanks chulett.