Convert Time Zone

object ScriptedField()
{
	String source = Starfish.OriginData["DATETIMERECEIVED"].ToString();
	DateTime dt = Convert.ToDateTime(source);
	TimeZoneInfo timeInfo = TimeZoneInfo.FindSystemTimeZoneById("Pacific Standard Time");
	return TimeZoneInfo.ConvertTime(dt, TimeZoneInfo.Utc, timeInfo);
}

• Related Articles

• Microsoft SQL Server Connector

  Overview The "SQL Server" Connector pulls data from Microsoft SQL Server. Using rowversion fields Many integrations run frequently and only want to pick up records modified since the last time the integration ran. This can be accomplished with ...

• Use the same job to loop through multiple origins

  This example looks at reading from multiple mailboxes for email. Use a variable in the origin connection string. If the job needs to run for another mailbox, it calls the GotoJob function in the “Once After Conn” and pass in the Job's ID. Similar ...

• Retrieve Records Modified After Last Run DateTime

  To only run data modified after the last time Starfish was run, we need to do two things: Set the last time Starfish ran. Filter the origin based on the last time Starfish ran. Set Last Run DateTime Create an After Operation Procedure and run the ...

• Salesforce Connector

  Additional Documentation This Connector is based on the Salesforce ADO.NET Provider by CData. For additional help, including Connection String parameters, please see: https://cdn.cdata.com/help/RFG/ado/ Salesforce Origin Case as Origin Table You ...

• Working with Variables

  StarfishETL variables can be used to store configurable information used by jobs and scripts. In the example below, several Variables have been defined. Use the following steps to walk through Viewing variables Selecting and changing a variable ...