sqlserver

SQL Server UDFs

This directory contains user-defined functions which mimic the behavior of proprietary functions in SQL Server. Each UDF within this directory will be automatically synchronized to the bqutil project within the ss dataset for reference in queries.

UDFs

• convert_datetime_string
• convert_timestamp_string
• convert_numeric_string
• convert_bytes_string
• convert_string_bytes

Documentation

convert_datetime_string(t DATETIME, mode INT64)

Emulates the CONVERT(VARCHAR, datetime_expression, style) expression from SQL Server as documented here.

convert_timestamp_string(t TIMESTAMP, mode INT64)

Emulates the CONVERT(VARCHAR, datetimeoffset_expression, style) expression from SQL Server as documented here.

convert_numeric_string(n ANY TYPE, mode INT64)

Emulates the CONVERT(VARCHAR, numeric_expression, style) expression from SQL Server as documented here.

convert_bytes_string(t BYTES, mode INT64)

Emulates the CONVERT(VARCHAR, varbinary_expression, style) expression from SQL Server as documented here.

convert_string_bytes(t STRING, mode INT64)

Emulates the CONVERT(VARBINARY, varchar_expression, style) expression from SQL Server as documented here.