MQSeries.net :: View topic - Date Formats in ESQL

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 » Date Formats in ESQL

Date Formats in ESQL

« View previous topic :: View next topic »

Author

Message

sanketpatel

Posted: Tue Nov 07, 2006 10:35 pm Post subject: Date Formats in ESQL

Apprentice

Joined: 31 Oct 2006
Posts: 40

Hi

How to get different date formats like

dd.mm.yyyy
yyyy.mm.dd
dd-mm-yyyy

usig ESQL ????????

Edde

Posted: Wed Nov 08, 2006 12:16 am Post subject:

Acolyte

Joined: 01 Oct 2006
Posts: 67
Location: Moscow, Russia

See here and here.

sanketpatel

Posted: Wed Nov 08, 2006 1:02 am Post subject:

Apprentice

Joined: 31 Oct 2006
Posts: 40

It will look like

SET OutputRoot.XML.Test.TIME2 = CAST(CURRENT_DATE AS CHARACTER FORMAT 'dd.MM.yyyy');
SET OutputRoot.XML.Test.TIME3 = CAST(CURRENT_DATE AS CHARACTER FORMAT 'dd-MM-yyyy');
SET OutputRoot.XML.Test.TIME4 = CAST(CURRENT_DATE AS CHARACTER FORMAT 'yyyy.MM.dd');

THANKS EDDE.......

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Date Formats in ESQL

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