MQSeries.net :: View topic - CURRENT_TIMESTAMP Problems with milliseconds

Luca81 · Posted: Fri Feb 01, 2008 1:59 pm Post subject:

Hi all,

we are migrating to Message Broker V6.
CURRENT_TIMESTAMP in V5 was in this format:

yyyy-mm-dd hh:mm:ss.fff

Now, in V6 is

yyyy-mm-dd hh:mm:ss.ffffff

And this is a problem for our applications.

This was the code in V5

SET OutputRoot.XMLNS.Header.Timestamp = CURRENT_TIMESTAMP

Output was like this
OutputRoot.XMLNS.Header.Timestamp = '2008-01-10 12:01:20.141'

In v6 the Output is like this
OutputRoot.XMLNS.Header.Timestamp = '2008-01-10 12:01:20.141453'

I need the old format...
So I used this code
CAST(CURRENT_TIMESTAMP AS CHARACTER FORMAT 'yyyy-MM-dd HH:mm:ss.SSS');

It works fine.
But I have a question, can't I use the FORMAT without the CAST?
I'd like a TIMESTAMP in the old format (yyyy-mm-dd hh:mm:ss.fff) without casting. Is it possibile? Or Have I to use this code?

DECLARE target TIMESTAMP;
SET target = CAST(CURRENT_TIMESTAMP AS TIMESTAMP FORMAT 'yyy-MM-dd HH:mm:ss');

Thx a Lot
Luca