Link to home
Start Free TrialLog in
Avatar of Sixpach71
Sixpach71

asked on

Date conversion using SQL/400

I have an eight character number field that I need to convert to a date in a query I'm putting together.  Example 20040105.  What is the exact syntax that I need to use with the Date function.

Thanks,

H
ASKER CERTIFIED SOLUTION
Avatar of RQnone
RQnone

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sixpach71
Sixpach71

ASKER

Cool.  I'll give it a shot.
Worked like a dream.  Thanks.  Now I'll figure out how to create the user function as you suggested.  

H
Alright.  

Thanks,

H