This will convert InputRoot.Properties.CreationTime from GMT to local time zone.
thanks everyone!!
I have no idea how that could work unless your local time zone was aligned with GMT.
But if it meets your requirements, then it's a win so go in peace.
Could it be because the raw data behind the timestamp and the gmttimestamp is the same, the rest is just a matter on how you display it? _________________ MQ & Broker admin
This works because the declared type of the putTime variable is TIMESTAMP, and there is an implicit cast in the assignment from GMTTIMESTAMP to TIMESTAMP.
The "+ INTERVAL '0' HOUR" doesn't do anything. The code should work just as well without it:
Code:
DECLARE putTime TIMESTAMP;
SET putTime = InRefProp.CreationTime;
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum