Sql Server 中的常用的日期格式化函数
我们一般在写查询语句的时候,都经常要根据时间的不同条件来筛选数据记录;下面就是Sql Server 中日期格式化函数 的一般使用
yourtime: 红色就是你要的日期时间
绿色 的表示常用的格式
CONVERT(varchar(100), yourtime , 0): 11 16 2010 10:57AM
CONVERT(varchar(100), yourtime , 1): 11/16/06
CONVERT(varchar(100), yourtime , 2): 06.11.16
CONVERT(varchar(100), yourtime , 3): 16/11/10
CONVERT(varchar(100), yourtime , 4): 16.11.10
CONVERT(varchar(100), yourtime , 5): 16-11-10
CONVERT(varchar(100), yourtime , 6): 16 11 10
CONVERT(varchar(100), yourtime , 7): 11 16, 10
CONVERT(varchar(100), yourtime , 8): 10:57:46
CONVERT(varchar(100), yourtime , 9): 11 16 2010 10:57:46:827AM
CONVERT(varchar(100), yourtime , 10): 11-16-10
CONVERT(varchar(100), yourtime , 11): 10/11/16
CONVERT(varchar(100), yourtime , 12): 101116
CONVERT(varchar(100), yourtime , 13): 16 11 2010 10:57:46:937
CONVERT(varchar(100), yourtime , 14): 10:57:46:967
CONVERT(varchar(100), yourtime , 20): 2010-11-16 10:57:47
CONVERT(varchar(100), yourtime , 21): 2010-11-16 10:57:47.157
CONVERT(varchar(100), yourtime , 22): 11/16/10 10:57:47 AM
CONVERT(varchar(100), yourtime , 23): 2010-11-16
CONVERT(varchar(100), yourtime , 24): 10:57:47
CONVERT(varchar(100), yourtime , 25): 2010-11-16 10:57:47.250
CONVERT(varchar(100), yourtime , 100): 11 16 2010 10:57AM
CONVERT(varchar(100), yourtime , 101): 11/16/2010
CONVERT(varchar(100), yourtime , 102): 2010.11.16
CONVERT(varchar(100), yourtime , 103): 16/11/2010
CONVERT(varchar(100), yourtime , 104): 16.11.2010
CONVERT(varchar(100), yourtime , 111): 16-11-2010
CONVERT(varchar(100), yourtime , 106): 16 11 2010
CONVERT(varchar(100), yourtime , 107): 11 16, 2010
CONVERT(varchar(100), yourtime , 108): 10:57:49
CONVERT(varchar(100), yourtime , 109): 11 16 2010 10:57:49:437AM
CONVERT(varchar(100), yourtime , 110): 11-16-2010
CONVERT(varchar(100), yourtime , 111): 2010/11/16
CONVERT(varchar(100), yourtime , 112): 20101116
CONVERT(varchar(100), yourtime , 113): 16 11 2010 10:57:49:513
CONVERT(varchar(100), yourtime , 114): 10:57:49:547
CONVERT(varchar(100), yourtime , 120): 2010-11-16 10:57:49
CONVERT(varchar(100), yourtime , 121): 2010-11-16 10:57:49.700
CONVERT(varchar(100), yourtime , 126): 2010-11-16T10:57:49.827
CONVERT(varchar(100), yourtime , 131): 18/04/1427 10:57:49:920AM