格式化日期时间 [英] Formatting Date Time
问题描述
我需要从SQL Server数据表中将日期时间格式设置为"YYYY-MM-DD HH:MM:SS",并将日期和时间存储在单独的列中.
我试图在后面的代码中进行转换
DateTime.ParseExact(ds.tables(0).rows(0).item(0).ToString&& ds.tables(0).rows(0).item(1)," YYYY-MM- DD HH:MM:SS,CultureInfo.InvariantCulture)
错误:字符串未被识别为有效的DateTime.
我还尝试在sql服务器查询中进行转换和选择
从TableName
中选择convert(datetime,DateColumnName + TimeColumnName,120)作为NewDatetime
错误:操作数数据类型日期对于添加运算符无效.
但是我得到了错误
帮我解决.
谢谢
Hi,
I require datetime format as ''YYYY-MM-DD HH:MM:SS'' from sql server data table where I''ve stored date, time in separate columns.
I tried to convert in code behind
DateTime.ParseExact(ds.tables(0).rows(0).item(0).ToString & " " & ds.tables(0).rows(0).item(1), "YYYY-MM-DD HH:MM:SS", CultureInfo.InvariantCulture)
Error: String was not recognized as a valid DateTime.
I also tried to convert and select in sql server query
select convert(datetime, DateColumnName + TimeColumnName, 120) as NewDatetime, from TableName
Error: Operand data type date is invalid for add operator.
But I get errors
Help me to resolve it.
Thanks
推荐答案
尝试
SELECT replace(convert(varchar, DateColumnName, 111), '/', '-') + ' ' + convert(varchar, TimeColumnName,108) AS NewDatetime FROM TableName
尝试如下操作:
try something like below :
SELECT CONVERT(VARCHAR(10), GETDATE(), 120) + ' ' + CONVERT(VARCHAR, GETDATE(),108) AS NEWDATETIME
这篇关于格式化日期时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!