Collections:
GET_FORMAT() - Standard Datetime Formats
How to get the format specifier string for a given datetime standards using the GET_FORMAT() function?
✍: FYIcenter.com
GET_FORMAT(part, std) is a MySQL built-in function that returns the format specifier string of a datetime part for a given standard. For example:
SELECT GET_FORMAT(DATETIME,'ISO'), GET_FORMAT(DATETIME,'USA'); -- +----------------------------+----------------------------+ -- | GET_FORMAT(DATETIME,'ISO') | GET_FORMAT(DATETIME,'USA') | -- +----------------------------+----------------------------+ -- | %Y-%m-%d %H:%i:%s | %Y-%m-%d %H.%i.%s | -- +----------------------------+----------------------------+ SELECT DATE_FORMAT(NOW(), GET_FORMAT(DATE, 'EUR')); -- +---------------------------------------------+ -- | DATE_FORMAT(NOW(), GET_FORMAT(DATE, 'EUR')) | -- +---------------------------------------------+ -- | 14.11.2023 | -- +---------------------------------------------+ SELECT DATE_FORMAT(NOW(), GET_FORMAT(DATETIME, 'EUR')); -- +-------------------------------------------------+ -- | DATE_FORMAT(NOW(), GET_FORMAT(DATETIME, 'EUR')) | -- +-------------------------------------------------+ -- | 2023-11-14 22.34.18 | -- +-------------------------------------------------+
Reference information of the GET_FORMAT() function:
GET_FORMAT(part, std): format Returns a format specifier string of a datetime part for a given standard std. part is a keyword of DATE, TIME or DATETIME. std is a standard name of 'EUR', 'USA', 'JIS', 'ISO' or 'INTERNAL'. Arguments, return value and availability: part: Required. The datetime part keyword. std: Required. The format standard name. format: Return value. The format specifier string. Available since MySQL 5.7.
⇐ FROM_UNIXTIME() - Unix Time to Datetime
2023-11-17, 261🔥, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...