Convert getdate() to CYYMMDD

I believe you want CONVERT() function with code 112 (ISO):
http://msdn.microsoft.com/en-us/library/ms187928.aspx

If my understanding is correct, CYYMMDD is same as YYYYMMDD as C is century, right?

SELECT CONVERT(VARCHAR(8), GETDATE(), 112)

CCYYMMDD = YYYYMMDD, but CYYMMDD is apparently different.

I think you can get your answers here...This article explains step by step procedure to covert SQL date into AS400 date

http://www.scriptsahead.com/sql-server/t-sql/convert-sql-date-into-as400-date-format

That is exactly what I had except they are only taking 7 characters, so you end up with 1081111.  Just change my code snippet above from:

SELECT RIGHT('00000000' + LTRIM(STR(CONVERT(VARCHAR(8), GETDATE(), 112) - 19000000)), 8)

To:

SELECT RIGHT('0000000' + LTRIM(STR(CONVERT(VARCHAR(8), GETDATE(), 112) - 19000000)), 7)

It is a flaw to only add one '0' as they have it though if you consider this date which occurs when you use 0 in SQL:
19000101

19000101-19000000 = 101
'0' + 101 = '0101'

This is not too big a deal since you are using getdate here, but programmitically why not be prepared as typing the 7 '0' is not that much harder. :)  Just my humble opinion though.

can also do  using the same format numbers, except subtract 100 to get two digit years (ie format 112 becomes 12):

using @d to emulate our datetime column or as a variable...

declare @d datetime
set @d = '19881126'

SELECT convert(varchar,left(year(@d),2) - 19) + convert(VARCHAR(6), @d, 12)

--or

SELECT convert(varchar,left(year(getdate()),2) - 19) + convert(VARCHAR(6), getdate(), 12)

Thank you for your help.