Localizing Dates In Sql Server
Several months ago I added timezone handling to a CF app. This post is my best effort to document how to localize dates using MSSQL timezone functionality.
Posts tagged “sql”
Articles about sql.
Storing and Using DateTimeOffsets in Lucee
Recently at Impelos I began storing dates using SQL Server's DateTimeOffset field, which allows us to store a date and time with embedded UTC offset. Unfortunately, I ran into several issues with Lucee's support for the data type.