in reply to Re^12: SQL query using elements from array
in thread SQL query using elements from array
If you look at your schema you are trying to select rows based on a timestamp but the column AuditChrt_TimeStamp is a char(10). That is not going to work.
The very first snippet of code you showed was binding '2013-08-01 00:00:00.000' which is also way too big for a char(10). I incorrectly assumed you actually had a timestamp column. In the future it sould save time if you provided the schema at the same time.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^14: SQL query using elements from array
by poj (Abbot) on Oct 29, 2014 at 12:22 UTC | |
by mje (Curate) on Oct 29, 2014 at 17:00 UTC | |
by AllPaoTeam (Acolyte) on Nov 03, 2014 at 19:47 UTC |
In Section
Seekers of Perl Wisdom