DB2/400 Timestamp (Dash between date & time)

[MStarkey]

We have an application that works with MS SQL. We are converting it to DB2/400. The timestamp format on the AS400 is yyyy-mm-dd-hh.mm.ss.xxxxx. The problem we have is the dash between the dd and the hh. Is there a way to get rid of this using the date/time format selections?
Thanks

 

[DBGod]

Try something like:-

SELECT SUBSTR(CHAR(timestamp),1,10)
CONCAT SUBSTR(CHAR(timestamp),12,15)
FROM table_name


Hope that helps


Mick

 

[flapeyre]

DB2/400's timestamp data type (Z) has that edit mask; I don't think you can get rid of the dash between the date and the time without separating them into date and time fields. Timestamps are not stored internally as a character field - they are stored as binary - the system will show them with the edit mask by default when using SQL.

When processing a timestamp field in a HLL (such as RPG IV or ILE Cobol), you can move them into separate date (type D) and time (type T) fields in just about any format you want.

DbGod's suggestion should work for SQL.
"Don't worry about the world coming to an end today. It's already tomorrow in Australia."
--Charles Schultz

 

[MStarkey]

Thanks very much. I think we have the issue resolved and you saved us some time. Thanks again.
Mike