mark2016
mark2016
/ ulid_converter.sql
Last active
February 26, 2025 19:49
— forked from kenji4569/ulid_converter.sql
ULID (26 characters in Crockford's base32) conversion for MySQL function
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Define ULID_DECODE and ULID_ENCODE which convert a ulid string to a binary and vice versa. | |
| /* This script is based on https://gist.github.com/kenji4569/47ce8bbd6bef7b85ba1f97e018f34cf3/forks | |
| # Changes made by mark2016: | |
| -- Original script didn't incorporate milliseconds into the timestamp, now they are included. | |
| -- Original script had a precision rounding error in function ULID_TO_DATETIME where the precision | |
| -- of the calculation resulted in milliseconds being lost, this is corrected. | |
| -- Functions are renamed with "app_" suffix to better differentiate them from native functions | |
| -- These functions are renamed: | |
| -- ULID_FROM_DATETIME => app_ulid_using_datetime |