Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
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!
Hi Shazad,
I think this may help you
Let vTime='10:00:00AM'
And in Load script with where condition
where DocCreateTime <'$(vTime)'
Thanks