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.
Problem with using SQL statement as parameter
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 34
- Joined: Thu Aug 28, 2014 8:48 pm
- Location: United States
-
- Premium Member
- Posts: 34
- Joined: Thu Aug 28, 2014 8:48 pm
- Location: United States