sql日期转换成yyyymmdd举例,sql里日期年月日转换成yyyymmdd形式
SQL Server2008时间转YYYYMMDD
1 select Convert(varchar(8), GETDATE(), 112)
2 go
--------
20110901
(1 行受影响)
如果你那里执行的结果是 2011-09-01, 就比较奇怪了.
你执行一下 下面的 SQL， 看看 哪种结果合适
SELECT 0 AS ID , Convert(VARCHAR(30), GETDATE(), 0 ) AS result UNION ALL
SELECT 100 AS ID , Convert(VARCHAR(30), GETDATE(), 100) AS result UNION ALL
SELECT 1 AS ID , Convert(VARCHAR(30), GETDATE(), 1 ) AS result UNION ALL
SELECT 101 AS ID , Convert(VARCHAR(30), GETDATE(), 101) AS result UNION ALL
SELECT 2 AS ID , Convert(VARCHAR(30), GETDATE(), 2 ) AS result UNION ALL
SELECT 102 AS ID , Convert(VARCHAR(30), GETDATE(), 102) AS result UNION ALL
SELECT 2 AS ID , Convert(VARCHAR(30), GETDATE(), 2 ) AS result UNION ALL
SELECT 102 AS ID , Convert(VARCHAR(30), GETDATE(), 102) AS result UNION ALL
SELECT 3 AS ID , Convert(VARCHAR(30), GETDATE(), 3 ) AS result UNION ALL
SELECT 103 AS ID , Convert(VARCHAR(30), GETDATE(), 103) AS result UNION ALL
SELECT 4 AS ID , Convert(VARCHAR(30), GETDATE(), 4 ) AS result UNION ALL
SELECT 104 AS ID , Convert(VARCHAR(30), GETDATE(), 104) AS result UNION ALL
SELECT 5 AS ID , Convert(VARCHAR(30), GETDATE(), 5 ) AS result UNION ALL
SELECT 105 AS ID , Convert(VARCHAR(30), GETDATE(), 105) AS result UNION ALL
SELECT 6 AS ID , Convert(VARCHAR(30), GETDATE(), 6 ) AS result UNION ALL
SELECT 106 AS ID , Convert(VARCHAR(30), GETDATE(), 106) AS result UNION ALL
SELECT 7 AS ID , Convert(VARCHAR(30), GETDATE(), 7 ) AS result UNION ALL
SELECT 107 AS ID , Convert(VARCHAR(30), GETDATE(), 107) AS result UNION ALL
SELECT 8 AS ID , Convert(VARCHAR(30), GETDATE(), 8 ) AS result UNION ALL
SELECT 108 AS ID , Convert(VARCHAR(30), GETDATE(), 108) AS result UNION ALL
SELECT 9 AS ID , Convert(VARCHAR(30), GETDATE(), 9 ) AS result UNION ALL
SELECT 109 AS ID , Convert(VARCHAR(30), GETDATE(), 109) AS result UNION ALL
SELECT 10 AS ID , Convert(VARCHAR(30), GETDATE(), 10 ) AS result UNION ALL
SELECT 110 AS ID , Convert(VARCHAR(30), GETDATE(), 110) AS result UNION ALL
SELECT 11 AS ID , Convert(VARCHAR(30), GETDATE(), 11 ) AS result UNION ALL
SELECT 111 AS ID , Convert(VARCHAR(30), GETDATE(), 111) AS result UNION ALL
SELECT 12 AS ID , Convert(VARCHAR(30), GETDATE(), 12 ) AS result UNION ALL
SELECT 112 AS ID , Convert(VARCHAR(30), GETDATE(), 112) AS result UNION ALL
SELECT 13 AS ID , Convert(VARCHAR(30), GETDATE(), 13 ) AS result UNION ALL
SELECT 113 AS ID , Convert(VARCHAR(30), GETDATE(), 113) AS result UNION ALL
SELECT 14 AS ID , Convert(VARCHAR(30), GETDATE(), 14 ) AS result UNION ALL
SELECT 114 AS ID , Convert(VARCHAR(30), GETDATE(), 114) AS result UNION ALL
SELECT 20 AS ID , Convert(VARCHAR(30), GETDATE(), 20 ) AS result UNION ALL
SELECT 120 AS ID , Convert(VARCHAR(30), GETDATE(), 120) AS result UNION ALL
SELECT 21 AS ID , Convert(VARCHAR(30), GETDATE(), 21 ) AS result UNION ALL
SELECT 121 AS ID , Convert(VARCHAR(30), GETDATE(), 121) AS result
SQL SERVER中日期的显示格式为YYYY-MM-DD,怎样设置为MM/DD/YYYY呢？
将SQL Server的日期显示格式修改为MM/DD/YYYY可以通过Convert函数，设置字段类型为Nvarchar两种方式实现，下面用SQL Server 2017具体演示一下：
1、准备要操作的数据，Birthday列默认是YYYY-MM-DD的格式，如下图所示
2、在Select中用Convert函数的101格式将birthday列转化为MM/DD/YYYY，如下图所示
3、打开表的设计界面，将字段的数据类型修改为nvarchar(50)，如下图所示
4、插入数据的时候直接插入MM/DD/YYYY格式的日期，如下图所示
Sql中的dateTime 怎么转换成 YYYY-MM-DD
1.确保数据库里LastReplytime是DateTime数据类型 2.修改下面这句： info.LastReplytime = DateTime.Now.Date; 如果想保留小时，分，秒可以这样： info.LastReplytime = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"); 不需要小时，分，秒可以
1.请写出将 Sql Server服务器的系统日期转换成格式为'yyyy-mm-dd'字符串的表达式
1). left(convert(varchar,getdate(),120),10) --转换成yyyy-mm-dd
2).时间差：datediff(day,'2004-03-22','2005-05-05')
SQL 怎么把DD-MM-YYYY格式的转换成YYYY/MM/DD?
可以尝试用以下语句来转换：(前提是ODATE字段是日期型date）
select to_char(ODATE,'YYYY/MM/DD') odate from 表名 where rownum=1;
如果ODATE是字符型的话，还要再转换一道：
select to_char(to_date(ODATE,'DD-MM-YYYY'),'YYYY/MM/DD') odate from 表名 where rownum=1;