使用Microsoft Sql Server:
---- Create test case--DECLARE @myDateTime DATETIMESET @myDateTime = '2008-05-03'---- Convert string--SELECT LEFt(ConVERT(VARCHAR, @myDateTime, 120), 10)

使用Microsoft Sql Server:
---- Create test case--DECLARE @myDateTime DATETIMESET @myDateTime = '2008-05-03'---- Convert string--SELECT LEFt(ConVERT(VARCHAR, @myDateTime, 120), 10)