This content has been marked as final. Show 9 replies
I want to compare two dates which are coming as strings in db
I created a flag field for comparing the times which is
if (timestamp(SCHEDULE_TIME,'h:mm TT') > (timestamp(Timestamp(now(0)-30/(24*60)),'h:mm TT')),1)
but every time I am getting the flag value as 1.
but ideally I should get flag as 0 for 9 AM entry.