MQSeries.net :: View topic - Date Format Validation 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 Format Validation in ESQL

Date Format Validation in ESQL

« View previous topic :: View next topic »

Author

Message

gaurav.udgir

Posted: Wed Aug 12, 2009 4:48 am Post subject: Date Format Validation in ESQL

Apprentice

Joined: 18 May 2009
Posts: 32

Hi All,

I am getting a XML File with date field (described as string in XSD). I want to validate that it is of Datetime datatype in ESQL. The date format which I will be getting is ISO. e.g. 2019-07-29T21:38:39.222. If the date is not valid I need to throw a exception.

If anyone has idea how to achieve thsi please help.

Thank you in advance.

Regards,
Gaurav

jbanoop

Posted: Wed Aug 12, 2009 5:06 am Post subject:

Chevalier

Joined: 17 Sep 2005
Posts: 401
Location: SC

try to cast it to timestamp using that format. If it causes an exception , you know that it is not in that format.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Date Format Validation 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