将Varchar日期转换为Date数据类型

2 回答

• 2

  我想你可以使用这样的查询：

  -- `monthes` is a raw data you need to do your convertion
  ;with monthes as (
      select '10' mn, 'Oct' md
      union all select '11', 'Nov'
      union all select '12', 'Dec'
      union all select '01', 'Jan'
      union all select '02', 'Feb'
      union all select '03', 'Mar'
      union all select '04', 'Apr'
      union all select '05', 'May'
      union all select '06', 'Jun'
      union all select '07', 'Jul'
      union all select '08', 'Aug'
      union all select '09', 'Sep'
  )
  select parsename(replace(t.dateColumn, '-', '.'), 2) + '-' + m.mn + '-2018' dateString
  from yourTable t
  left join monthes m 
    on m.md= parsename(replace(t.dateColumn, '-', '.'), 1);
  

  回复于 2024-04-17T02:02:13+08:00
• 0

  假设年份应始终在当年，这是一种方法：

  DECLARE @StringDate char(10) = 'Mon-01-Oct'
  
  SELECT CONVERT(Date, 
                 REPLACE(RIGHT(@StringDate, 6), '-', ' ') +' '+ 
                 CONVERT(char(4), GETDATE(), 120),
                 106) As DateValue
  

  结果：

  2018-10-01
  

  回复于 2024-04-17T02:02:13+08:00