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, 1768🔥, 0💬
Popular Posts:
How to check if two JSON values have overlaps using the JSON_OVERLAPS() function? JSON_OVERLAPS(json...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...