s-Server features a number of conversion functions. Many of these involve dates and timestamps. Date and time patterns are summarized here.
NOTE: As well as the functions listed below, the CAST operator can be used for many conversions including either way between CHAR / VARCHAR and DATE / TIME / TIMESTAMP.
|CHAR_TO_DATE||Converts a CHAR or VARCHAR to a DATE|
|CHAR_TO_TIME||Converts a CHAR or VARCHAR to a TIME|
|CHAR_TO_TIMESTAMP||Converts a CHAR or VARCHAR to a TIMESTAMP|
|DATE_TO_CHAR||Returns a VARCHAR representation of a time|
|MILLIS_TO_TIMESTAMP||Converts a Unix epoch time (in milliseconds) to a TIMESTAMP. The epoch is an BIGINT value such as is produced by the UNIX_TIMESTAMP function.|
|TIME_TO_CHAR||Returns a VARCHAR representation of a time|
|TIMESTAMP_TO_CHAR||Returns a VARCHAR representation of a time|
|TO_TIMESTAMP||Converts a Unix epoch time (in milliseconds) to a TIMESTAMP. The epoch is an BIGINT value such as is produced by the UNIX_TIMESTAMP function.|
|UNIX_TIMESTAMP||Converts a timestamp to a Unix timestamp (milliseconds since ‘1970-01-01 00:00:00’ UTC) as a BIGINT.|
See also Date and Time Patterns in this guide.
|VARBINARY_TO_STRING||Convert a VARBINARY to a VARCHAR using the supplied character set.|
|VARBINARY_TO_VARCHAR||Represent a VARBINARY as a hex-encoded VARCHAR.|
|VARCHAR_TO_VARBINARY||Convert a hex encoded CHAR or VARCHAR to VARBINARY.|