asked on Formatting date to mm/dd/yyyy
I read the date field in AS400 database, and it looks like this:
2007-01-12
anyway i can display it/ format it as mm/dd/yyyy with a command? or do I need to parse it and put it back together?
in sql server, i use convert(varchar(12),mydate
2007-01-12
anyway i can display it/ format it as mm/dd/yyyy with a command? or do I need to parse it and put it back together?
in sql server, i use convert(varchar(12),mydate
DB2
Last Comment
Camillia
you should be able to use TO_CHAR(yourfield, 'MM/DD/YYYY')
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
TO_CHAR is not recognized. Let me go thru that link and see...
ASKER
Tried VARCHAR_FORMAT as well, didnt work...
select To_CHAR(chadat,'MM/DD/YYYY
gives me the error : TO_CHAR in *LIBL type *N not found..
the field in the database is "Date"..is it because of the version of iSeries/As400??
select To_CHAR(chadat,'MM/DD/YYYY
gives me the error : TO_CHAR in *LIBL type *N not found..
the field in the database is "Date"..is it because of the version of iSeries/As400??
ASKER
That article is for DB2 windows/Linux. so that wont work for me..
I tried
Select
Char( Date('1978-01-27', USA ) )
From
Sysibm.Sysdummy1
but got the error :USA is not defined in table..
any ideas?
I tried
Select
Char( Date('1978-01-27', USA ) )
From
Sysibm.Sysdummy1
but got the error :USA is not defined in table..
any ideas?
ASKER
found my answer
Select
Char(Date('1978-01-27'),US
From
Sysibm.Sysdummy1
Select
Char(Date('1978-01-27'),US
From
Sysibm.Sysdummy1
This works for me on DB2 for iSeries (AS/400) v5r3
select char(effectiveDate, USA)
from coverageperiod
I think you forgot a parenthesis in your query. (right after the date)
HTH,
DaveSlash
ASKER
yeah, thanks..
anway to have it as dd/mm/yyyy as well??
anway to have it as dd/mm/yyyy as well??
This gets you close ...
Select
Char( effectiveDate, EUR )
From
coverageperiod
You might also try:
Select
Char( effectiveDate, LOCAL )
From
coverageperiod
HTH,
DaveSlash
ASKER
Thanks Dave.