Connx / SQL / simple question: Natural Timestamp / different format => YYYYMMDD HH:MM:SS

[ChristianHeld]

Hi everybody

we use ACE version 14.50.21007 to retrieve Mainframe ADABAS Data.

Assume there is a column defined as “natural timestamp”.

When I place a SELECZ like this

SELECT convert(Nat_Timestamp, char(21)) the result is 2001-12-10 14:17:28.1

in general YYYY-MM-DD HH:MM:SS.T

Question: Is there a trick to get the Nat_Timestamp in the structure YYYYMMDD HH:MM:SS.T ?

I checked the documentation, but found no elegant solution.

Any help ist welcomed.

Regards Chris

[anon27083125]

Please try this: Replace( convert(Nat_Timestamp, char(21)) , ‘-’, ‘’)

[ChristianHeld]

Hi Larry. THX, it works perfect.
Bye Chrisitan