将美国日期格式转换为ANSI SQL日期格式(YYYY-mm-dd)

SELECT CONVERT(varchar(10), date_column, 120) AS ansi_date;

SELECT FORMAT(date_column, 'yyyy-MM-dd') AS ansi_date;

from datetime import datetime

date_str = '01/01/2022'
date_obj = datetime.strptime(date_str, '%m/%d/%Y')
ansi_date = date_obj.strftime('%Y-%m-%d')

import java.text.SimpleDateFormat;
import java.util.Date;

String dateStr = "01/01/2022";
SimpleDateFormat sdf = new SimpleDateFormat("MM/dd/yyyy");
Date date = sdf.parse(dateStr);
sdf.applyPattern("yyyy-MM-dd");
String ansiDate = sdf.format(date);