MQSeries.net :: View topic - reformat date pattern

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 » reformat date pattern

reformat date pattern

« View previous topic :: View next topic »

Author

Message

dosttumhara1810

Posted: Mon Jan 13, 2014 12:30 am Post subject: reformat date pattern

Voyager

Joined: 01 Dec 2010
Posts: 76

hi ,

I am getting date as yyyy-mm-dd from channels , i want to send it as dd-mm-yyyy to host. Is there any shortest way/function to do that in esql.
i dont want to use substring function to substring dd,mm,yyyy and then format to dd-mm-yyyy.

smdavies99

Posted: Mon Jan 13, 2014 1:00 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

cast from CHAR to DATE type using the format verb
cast from DATE to CHAR type using the format verb
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » reformat date pattern

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