JavaScript Date objects nested inside VARIANT objects are always of type TIMESTAMP_LTZ(3). TIMESTAMP_LTZ(3) to the return data type. JavaScript Date objects are converted to the UDF’s result data type, adhering to the same conversion semantics as casts from SQL DATE is converted to JavaScript Date representing midnight of the current day in the local time zone.Īdditionally, consider the following notes for JavaScript UDFs that return DATE and TIMESTAMP types:
Input (similar to when converting TIMESTAMP_TZ to TIMESTAMP_LTZ). This is similar to behavior when converting TIMESTAMP_NTZ to TIMESTAMP_LTZ.Ī JavaScript Date generated from SQL TIMESTAMP_TZ loses time zone information, but represents the same moment in time as the The JavaScript date type is equivalent toĬonsider the following notes for JavaScript UDFs that accept a date or time:Īll precision beyond milliseconds is lost.Ī JavaScript Date generated from SQL TIMESTAMP_NTZ no longer acts as “wallclock” time it is influenced by daylight saving time. All timestamp and date types are converted into JavaScript Date() objects.
0 kommentar(er)
