如何在Db2 I5 / Os中将字符串'Ddmmyyyy'转换为日期时间'Dd / Mm / Yyyy' [英] How Can I Covert String 'Ddmmyyyy' To Datetime 'Dd/Mm/Yyyy' In Db2 I5/Os
问题描述
当我尝试从列名转换数据时遇到问题:'date'(字符串:ddmmyyyy ex:09032015)到fomat datetime(DD) / MM / YYYY)我正在使用提供商IBMDA400。
我使用一些命令尝试转换但未成功。
我的目的只是从数据库中选择数据,但Visual Studio总是显示错误。
ex:
Cmd1:从表中选择日期(to_date(我的字符串,'dd / mm / yyyy')
- >在这里出现错误:SQ20448:表达式无效使用格式为TIMESTAMP_FORMAT指定的字符串。
我改变了:'TIMESTAMP_FORMAT'而不是'TO_DATE'
cmd2:选择TIMESTAMP_FORMAT(mystring,'DD / MM / RRRH HH24:MI')
- >错误SQ20448继续发生。
请帮助我!!
非常感谢:D
因为你有一个日期存储在字符串中DDMMYYYY的rmat,首先你必须将其转换为实际日期:
DATE (TO_DATE(date_string) ,' DDMMYYYY'))
结果是二进制日期,现在可以转换为任何字符串...
CHAR ( DATE (TO_DATE(date_string,' DDMMYYYY') ),美国)
AS400只有预先定义的格式,所以'USA'会给你MM / DD / YYYY而不是DD / MM / YYYY ......你可以尝试'EUR',它将提供DD.MM.YYYY而不是替换。 (点)到/(斜杠)......
在这里查看其他选项: http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/db2/rbafzmstch2func.htm [ ^ ]
Hi,
I have a problem when I try converting data from column name:'date'(string: ddmmyyyy ex:09032015) to fomat datetime (DD/MM/YYYY) and I'm using provider IBMDA400.
I use some commands to try converting but have not been successful.
My purpose is only select data from database but Visual Studio always displays error.
ex:
Cmd1: select date(to_date(my string,'dd/mm/yyyy') from table
-> In here appear error: SQ20448: Expression not valid using format string specified for TIMESTAMP_FORMAT.
And I changed: 'TIMESTAMP_FORMAT' instead of 'TO_DATE'
cmd2: select TIMESTAMP_FORMAT(mystring, 'DD/MM/RRRR HH24:MI')
-> Error SQ20448 continue to occur.
pls help me!!
thanks so much :D
As you have a date stored in string in the format of DDMMYYYY, first you have to convert it into a real date:
DATE(TO_DATE(date_string, 'DDMMYYYY'))
The result is a binary date and can be converted to any string now...
CHAR(DATE(TO_DATE(date_string, 'DDMMYYYY')), USA)
AS400 has only pre-defined formats, so 'USA' will give you MM/DD/YYYY instead of DD/MM/YYYY...You may try 'EUR' that will give DD.MM.YYYY and than replace . (dot) to / (slash)...
Check other options here: http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/db2/rbafzmstch2func.htm[^]
这篇关于如何在Db2 I5 / Os中将字符串'Ddmmyyyy'转换为日期时间'Dd / Mm / Yyyy'的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!