仅获取日期时间列的日期部分

// 假设dateValue是日期时间列的值
var dateValue = new Date();
var datePart = dateValue.toISOString().split('T')[0];
console.log(datePart);

import datetime

# 假设dateValue是日期时间列的值
dateValue = datetime.datetime.now()
datePart = dateValue.date()
print(datePart)

import java.time.LocalDateTime;
import java.time.LocalDate;

// 假设dateValue是日期时间列的值
LocalDateTime dateValue = LocalDateTime.now();
LocalDate datePart = dateValue.toLocalDate();
System.out.println(datePart);

SELECT DATE(dateColumn) FROM tableName;

SELECT TRUNC(dateColumn) FROM tableName;