cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Expression Library: Database DateTime Conversion

dmiller
Admin Admin
Admin

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โ€}))
}

Diane Miller
Community Manager
0 REPLIES 0