โ03-25-2019 05:13 PM
The expressions for database datetime conversions listed in the topic SnapLogic DateTime Conversion Guidelines can be updated as follows to build an expression library:
{
/*
* Database DateTime Conversions
* Sample conversions between the SnapLogic DATETIME variable and several known 3rd party data types normalized to the US/Pacific time zone.
*/
toRedshiftDate: x => LocalDate.parse(x.toLocaleDateString({"timeZone":"US/Pacificโ})) ,
toRedshiftTimestamp: x => LocalDateTime.parse(x.toLocaleDateTimeString({"timeZone":"UTCโ})) ,
toMongoDBDateTime: x => LocalDateTime.parse(x.toLocaleDateTimeString({"timeZone":"US/Pacificโ})) ,
toMySQLDate: x => LocalDate.parse(x.toLocaleDateString({โtimeZoneโ:"US/Pacificโ})) ,
toMySQLDateTime: x => LocalDateTime.parse(x.toLocaleDateTimeString({โtimeZoneโ:"UTCโ})) ,
toMySQLTime: x => LocalTime.parse(x.toLocaleTimeString({โtimeZoneโ:"US/Pacificโ})) ,
toMySQLTimeStamp: x => LocalDateTime.parse(x.toLocaleDateTimeString({โtimeZoneโ:"US/Pacificโ})) ,
toOracleDate: x => LocalDate.parse(x.toLocaleDateString({โtimeZoneโ:"US/Pacificโ})) ,
toOracleTimeStamp: x => LocalDateTime.parse(x.toLocaleDateTimeString({โtimeZoneโ:"UTCโ})) ,
toOracleTimeStampTMZ: x => LocalDateTime.parse(x.toLocaleDateTimeString({โtimeZoneโ:"US/Pacificโ})) ,
toOracleTimeStampLocalTMZ: x => LocalDateTime.parse(x.toLocaleDateTimeString({โtimeZoneโ:"US/Pacificโ})) ,
toPostgresDate: x => LocalDate.parse(x.toLocaleDateString({โtimeZoneโ:"US/Pacificโ})) ,
toPostgresTime: x => LocalTime.parse(x.toLocaleTimeString({โtimeZoneโ:"UTCโ})) ,
toPostgresTimeTMZ: x => LocalTime.parse(x.toLocaleTimeString({โtimeZoneโ:"US/Pacificโ})) ,
toPostgresTimeStamp: x => LocalDateTime.parse(x.toLocaleDateTimeString({โtimeZoneโ:"UTCโ})) ,
toPostgresTimeStampTMZ: x => LocalTime.parse(x.toLocaleTimeString({โtimeZoneโ:"US/Pacificโ})) ,
toSAPHANADate: x => LocalDate.parse(x.toLocaleDateString({โtimeZoneโ:"US/Pacificโ})) ,
toSAPHANATime: x => LocalTime.parse(x.toLocaleTimeString({โtimeZoneโ:"US/Pacificโ})) ,
toSAPHANASecondDate: x => LocalDateTime.parse(x.toLocaleDateTimeString({โtimeZoneโ:"UTCโ})) ,
toSAPHANATimeStamp: x => LocalDateTime.parse(x.toLocaleDateTimeString({โtimeZoneโ:"UTCโ})) ,
toSalesforceDate: x => LocalDate.parse(x.toLocaleDateString({โtimeZoneโ:"US/Pacificโ})) ,
toSalesforceDateTime: x => LocalDateTime.parse(x.toLocaleDateTimeString({โtimeZoneโ:"UTCโ})) ,
toSalesforceTime: x => LocalTime.parse(x.toLocaleTimeString({โtimeZoneโ:"US/Pacificโ})) ,
toSQLDateTime: x => LocalDateTime.parse(x.toLocaleDateTimeString({โtimeZoneโ:"UTCโ})) ,
toSQLDateTime2: x => LocalDateTime.parse(x.toLocaleDateTimeString({โtimeZoneโ:"UTCโ}))
}