how many "n"s can you find in:
q: add or subtract hours from today and yesterday functions in soql i have to run a load every 6 am in the morning, so just wanted those records that have been updated or created since this time i.e yesterday 6 am and today 6 am. i was thinking to use a logic to add 6 hours in yesterday function to make it 6 am 7 subtract 18 hours from today function to make it 6am, but evrytime i do this i receive an error sometime mall function query or sometime bind functions not allowed. can anyone provide me the exact query for the same ? this is on high priority, i am using jitterbit for this.

a: you can use date formats and date literals together with date functions directly in the soql query:
select id 
from account
where createddate = today
and hour_in_day(createddate) = 6


a: you could do a soql query with system.now() for current time and system.now()-1 for yesterday's current time like below.
list<case> c = [select id from case where createddate <: system.now() and createddate >: system.now()-1];

if the batch starts execution by 6.03 am today, it will fetch all the records created between 6.03 am today and 6.03 am yesterday.
update:
if the minute level accuracy is required we could do the following in apex batch class but not sure how to do that in informatica.
datetime dt1 = datetime.newinstancegmt(system.now().year(),system.now().month() ,system.now().day(),system.now().hour(),0,0);
datetime dt2 = datetime.newinstancegmt(system.now().year(),system.now().month() ,system.now().day()-1,system.now().hour(),0,0);
list<case> c = [select id from case where createddate <: dt1 and createddate >: dt2];

hope it helps.

user
I counted 73 "n"s in that text.
assistant