将字符串格式yyyy-mm-dd转换为dd / mm / yyyy [英] convert string format yyyy-mm-dd to dd/mm/yyyy

问题描述

Ive目前有一个问题，将ms sql表中的字符串字段转换为我所需的日期格式。

Ive currently got an issue with converting a string field in a ms sql table to my desired date format.

以前我一直使用

CONVERT(date,c.INP_DATE ,103)

但这会给我错误

[Err] 22007 - [SQL Server]Conversion failed when converting date and/or time from character string.

我有两个样本记录是2013-09-18和2013-09-18 17:17： 32.0000000我通过mysql从import导入。我需要这些转换为dd / mm / yyyy与适用的时间。

two sample records i have are 2013-09-18 and 2013-09-18 17:17:32.0000000 which i receive from an import via mysql. I need these converted to dd/mm/yyyy with time where applicable.

任何大师的帮助，赞赏：）

Any help from any gurus out there is appreciated :)

推荐答案

DECLARE @a VARCHAR(50) = '2013-09-18'
, @b VARCHAR(50) = '2013-09-18 17:17:32.0000000'

SELECT CONVERT(VARCHAR(10),CAST(@a as DATE),103)
 , CONVERT(VARCHAR(10),CAST(@b as DATE),103)

这篇关于将字符串格式yyyy-mm-dd转换为dd / mm / yyyy的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！