How do i compare a time in If condition i.e.
I have a DocCreateTime field (carrying just time with format: 11:05:30AM ) coming from database. I just want records, having time value lesser than 10:00:00AM.
How do i do that ?
Help Required please!
I think this may help you
And in Load script with where condition
where DocCreateTime <'$(vTime)'
Retrieving data ...