Re: Convert YYMMDD to Date in SQL

Try the idate function recommended. Or

SELECT

CENTURY, YY, MM, DD, DATE(
CASE WHEN CENTURY = '0' THEN '19' ELSE '20' END
CONCAT DIGITS(YY) CONCAT '-' CONCAT DIGITS(MM) CONCAT '-' CONCAT
DIGITS(DD))
FROM QTEMP/WILLS

....+....1....+....2....+....3....
CENTURY YY MM DD DATE
0 61 8 29 1961-08-29
1 11 8 29 2011-08-29
******** End of data ********

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Mike <koldark@xxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Date: 07/12/2010 11:54 AM
Subject: Convert YYMMDD to Date in SQL
Sent by: midrange-l-bounces@xxxxxxxxxxxx



A vendor provides the date in four fields C (1 or 0), YY (2 digits), MM,
DD.
I want to take them and convert it to a DATE field in SQL. Apparently
YYMMDD
is not a good Google search term and I can't find decent sample of this. I
know how to join the fields into a single field to YYMMDD or MMDDYY but
it's
the process of converting that to a DATE field that I am having problems
with. Any ideas?

I just may add 20 to the YY and let some poor fool fix it in 90 years. The
file only contains data for the current year so no worrying about 1900s.

--
Mike Wills
http://mikewills.info
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.