国产成人精品亚洲日本在线_欧美精品v国产精品v_亚洲欧洲日韩国产一区二区三区_亚洲乱码一二三四区

-- 示例數(shù)據(jù)
CREATE TABLE orders (
    id INT PRIMARY KEY,
    product_name VARCHAR(100),
    created_at DATETIME
);

INSERT INTO orders VALUES (1, 'Laptop', '2023-10-27 15:30:05');
INSERT INTO orders VALUES (2, 'Mouse', '2023-01-05 09:08:07');

SELECT 
    id,
    product_name,
    created_at,
    DATE_FORMAT(created_at, '%Y-%m-%d') AS formatted_date
FROM 
    orders;

SELECT 
    id,
    DATE_FORMAT(created_at, '%Y年%m月%d日 %H:%i:%s') AS formatted_datetime
FROM 
    orders;

SELECT 
    id,
    DATE_FORMAT(created_at, '%H:%i') AS order_time
FROM 
    orders;

SELECT 
    id,
    DATE_FORMAT(created_at, '%M %d, %Y') AS english_date
FROM 
    orders;

SELECT 
    id,
    DATE_FORMAT(created_at, 'Order placed on %W, %M %e, %Y at %h:%i %p') AS full_description
FROM 
    orders;

-- 將字符串 '2023年10月27日' 轉(zhuǎn)換為 DATE 類(lèi)型
SELECT STR_TO_DATE('2023年10月27日', '%Y年%m月%d日') AS converted_date;
-- 結(jié)果: 2023-10-27

-- 將字符串 '15:30:05' 轉(zhuǎn)換為 TIME 類(lèi)型
SELECT STR_TO_DATE('15:30:05', '%H:%i:%s') AS converted_time;
-- 結(jié)果: 15:30:05