I want to query a triggered send to get the sends done in last 30 days. I am using the following SQL query
select SubscriberKey,EventDate as SentTime,JobID from _Sent TriggeredSendCustomerKey = 10411 and EventDate > dateadd(d,-30,getdate())
However the system is retuirng the sent in last 30 days in UTC time zone. I want to get the results in Melbourne, Australia Time Zone. Is there a way to achive it?