agbeer
Member
Hi there,
I am using the following SQL statement to convert dates from Julian in AS400 iSeries Navigator SQL tool.
select date(char(sddrqj+1900000))
from f4211
This returns the date in a yyyy-mm-dd format, can anyone advise how to convert this to dd-mm-yyyy?
Thanks in advance.
Andy.
I am using the following SQL statement to convert dates from Julian in AS400 iSeries Navigator SQL tool.
select date(char(sddrqj+1900000))
from f4211
This returns the date in a yyyy-mm-dd format, can anyone advise how to convert this to dd-mm-yyyy?
Thanks in advance.
Andy.