I need help for extracting data from date column very urgent

Question

question

mahi222 asked Jun 4, '15

I need help for extracting data from date column very urgent

i have a column FiscalYear='FY2014' but I need output like 'FY14' how to extract it I tried using functions like left and right

functions

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey ♦♦ commented · Jun 08, 2015 at 10:48 AM

ASK SQL Server Central runs by you voting. For all helpful answers below, please indicate this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate this by clicking on the check mark next that answer.

0 ·

Answer 1 · 2015-06-04T10:50:54Z

David Wimbush answered Jun 4, '15

If they always have the same format, you could use this: 'FY' + reverse(substring(reverse(FiscalYear),1,2)). I just hope you don't have any dates that are not 2000-2999. (I worked on the Y2K 'bug' and still bear the scars!) In my opinion, FY2014 is actually better.

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 2 · 2015-06-05T09:54:28Z

erlokeshsharma08 answered Jun 5, '15

DECLARE @VA VARCHAR(6) SET @VA = 'fy2099' select CASE WHEN right(@VA,'3') < 100 THEN LEFT(@VA,'2') +right(@VA,'2') ELSE @VA END AS LOK

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 3 · 2015-06-08T18:45:49Z

Alvin Ramard answered Jun 8, '15

What about: REPLACE(FiscalYear, '20', '')

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 4 · 2015-06-09T04:51:43Z

Venkataraman answered Jun 9, '15

SELECT 'FY'+ RIGHT(RIGHT('fy2014',4),2)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

question