MQSeries.net :: View topic - Changing CDT to GMT

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Changing CDT to GMT

Changing CDT to GMT

« View previous topic :: View next topic »

Author

Message

jorro004

Posted: Fri Sep 21, 2007 8:47 am Post subject: Changing CDT to GMT

Acolyte

Joined: 25 Aug 2007
Posts: 50

Hi Masters,

Can anyone help me in changing the Input Date value
'yyyy-MM-dd hh:mm:ss.SSSSSS CDT' to GMT TIME STAMP

I searched entire documentation, BUt didnt find any documentation to change CDT timestamp to GMT.There are functions to get current GMT timestamp but not exactly conversions

Can some help me please?

Thanks

"

fjb_saper

Posted: Sat Sep 22, 2007 5:05 am Post subject: Re: Changing CDT to GMT

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

jorro004 wrote:

How about 'yyyy-MM-dd hh:mm:ss.SSSSSS ZZZ'
_________________
MQ & Broker admin

AkankshA

Posted: Mon Sep 24, 2007 3:41 am Post subject:

Grand Master

Joined: 12 Jan 2006
Posts: 1494
Location: Singapore

if i got u correctly

CAST as GMTTIMESTAMP shall help u..

if not then use interval function to get the time diff b/w CDT and GMT and add up that to get GMT...

u shall be able to achivee it with just 1-2 lines of eSQL

happy coding
_________________
Cheers

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Changing CDT to GMT

Jump to:

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

Protected by Anti-Spam ACP