Home > IT Answers > AS/400 > How do I convert a date in text format to a proper date with AS/400 Query
PhilipX
25 pts.
 How do I convert a date in text format to a proper date with AS/400 Query
AS/400, AS/400 Query
I have a date 20/02/2013 which is in text format but I need to convert it to a date format with a length of 10 and decimal of L (a normal date format). Basically I need to convert 20/02/2013 which is currently in text format to an ISO date format with Query using iSeries access for Windows.

Software/Hardware used:
AS400 Query
ASKED: February 21, 2013  11:22 AM
UPDATED: February 21, 2013  2:07 PM
RELATED QUESTIONS
 
  Help
 Approved Answer - Chosen by PhilipX (Question Asker)

This is something I have done in the past, but right now I do not have access to the AS400 Querry screen.When you build your query, if I remember correctly, the 2nd selection line allow you to define new fields. Go to that screen and press F1 for HELP. There is detail instructions on how to do what you want.

ANSWERED:  Feb 21, 2013  1:29 PM (GMT)  by PhilipX
 
Other Answers:

I have amanged to find an online manual which illustrates how to difine the statement.

Many thanks for your thoughts.

 

Last Wiki Answer Submitted:  February 21, 2013  4:07 pm  by  PhilipX   25 pts.
Latest Answer Wiki Contributors:  PhilipX   25 pts. , Michael Tidmarsh   14,060 pts.
To see other answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

“…a length of 10 and decimal of L (a normal date format).” That doesn’t make sense. A physical file data type of “L” will set a DATE data type for a field, but there cannot be a “decimal” attribute nor will the field have a length attribute. Since you associated this with “AS/400 Query”, please include what kind of query this relates to. QM Query? SQL query? OPNQRYF? Query for iSeries? — Tom

TomLiotta
 110,215 pts.