Popular Posts

  • Error: 18056, Severity: 20, State: 23
    SQLServerCentral » Latest topics Error: 18056, Severity: 20, State: 23 Hi.. Error: 18056, Severity: 20, State: 23. Message The clie...
  • sp_helpindex2
    SQLblog.com - The SQL Server blog spot on the web sp_helpindex2 --my extension of sp_helpindex: sp_helpindex2 USE master GO IF EXIS...
  • SSMS for Linux
    SQLServerCentral » Latest topics SSMS for Linux I can't find information on the Web about whether Microsoft plans to develop an...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Friday, June 30, 2017

Split DATE formatted 'YYYY-MM-DD' into Concatenated YEAR and MO field

SQLServerCentral » Latest topics
Split DATE formatted 'YYYY-MM-DD' into Concatenated YEAR and MO field
Hello, I have a date field in the DATE in the format of 'YYYY-MM-DD' and how it is displayed, and I'm trying to split our Year and Month and concatenate into 'YYYYMM' format. I've tried DATEPART, DATEADD and  other variations and I'm not quite gettin
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)