Database Date Types

As databases support different date-related formats, the following table clarifies compatibility with those formats and the SnapLogic expression language methods of toLocaleDateString()/toLocaleDateTimeString()/toLocaleTimeString() in Mapper Snap. In general, only those database types that are outputted as Joda DateTime objects can be used with the toLocale methods. To get string values of the other date types use toString().


Database data typeOutput type from Select/ExecuteCompatible with toLocaleDateString() /
toLocaleDateTimeString() / toLocaleTimeString()
AzureSQL
DateLocalDate

Not Compatible  

DateTimeLocalDateTimeNot Compatible
Datetime2LocalDateTimeNot Compatible
DateTimeOffsetDateTimeCompatible
SmallDateTimeLocalDateTimeNot Compatible
TimeLocalTimeNot Compatible
Hive  
DateLocalDate

Not Compatible  

TimestampDateTimeNot Compatible
Snowflake
Date          LocalDateNot Compatible
Datetime LocalDateTimeNot Compatible
Timestamp with Local Time ZoneTimestamp with Time ZoneNot Compatible
LocaldatetimeLocalDateTimeNot Compatible
Time Localtime Not Compatible
MongoDB

DateDateTime Compatible
TimestampStringNot compatible
Google BigQuery
DateDatetimeCompatible
TimeLocalTimeNot Compatible
DateTimeDateTimeCompatible
TimestampDateTimeCompatible

SQL Server

DateLocalDateNot Compatible
DateTimeLocalDateTimeNot Compatible
Datetime2LocalDateTimeNot Compatible
DateTimeOffsetDateTimeCompatible
SmallDateTimeLocalDateTimeNot Compatible
TimeLocalTimeNot Compatible
Oracle
DateLocalDateTimeNot Compatible
TimestampNot CompatibleNot Compatible
Timestamp with Time ZoneDateTimeCompatible
Timestamp with Local Time ZoneLocalDateTimeNot Compatible
MySQL
DateLocalDateNot Compatible
TimeLocalTimeNot Compatible
DateTimeLocalDateTimeNot Compatible
TimestampDateTimeCompatible
Redshift
TimestampLocalDateTimeNot Compatible
DateLocalDateNot Compatible
TimeLocalTimeNot Compatible
PostgreSQL
TimestampLocalDateTimeNot Compatible
Timestamp with Time ZoneDateTimeCompatible
TimeLocalTimeNot Compatible
Time with Time ZoneStringNot Compatible
DateLocalDateNot Compatible
SAP HANA
DateLocalDateNot Compatible
TimestampDatetimeCompatible
TimeLocalTimeNot Compatible
Cassandra
DateDateTimeCompatible
Vertica
TimeStampLocalDateTimeNot Compatible
Timestamp with Time ZoneLocalDateTimeNot Compatible
Time with Time ZoneLocalDateTimeNot Compatible
DateLocalDateNot Compatible
TimeLocalTimeNot Compatible