<div>
<div class="content wysiwyg-content">
I'm reading in a file and I have a six character date field coming in like this: &nbsp;060299<br />
so, it's month day year format.<br />
I know I need a y2k check so I can add 20 or 19 to my year field.<br />
<br />
But does anyone have a good function to format the rest of my string.<br />
<br />
I think db2 expects the date in this format: '0001-01-01-00.00.00.00.00<wbr />00'<br />
for date and timestamp.<br />
<br />
Thanks in Advance.<br />
John <br />

</div>
</div>


I'm reading in a file and I have a six character date field coming in like this:  060299
so, it's month day year format.
I know I need a y2k check so I can add 20 or 19 to my year field.

But does anyone have a good function to format the rest of my string.

I think db2 expects the date in this format: '0001-01-01-00.00.00.00.0000'
for date and timestamp.

Thanks in Advance.
John 


Format 6-Character Date Field For DB2

C is a general-purpose, imperative computer programming language, supporting structured programming, lexical variable scope and recursion, while a static type system prevents many unintended operations. By design, C provides constructs that map efficiently to typical machine instructions, so it has found lasting use in applications that had formerly been coded in assembly language, including operating systems as well as various application software for computers ranging from supercomputers to embedded systems. It is distinct from C++ (which has its roots in C) and C#, and many later languages have borrowed directly or indirectly from C.