MQSeries.net :: View topic - CAST() time change formatt problem inESQL

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 » CAST() time change formatt problem inESQL

CAST() time change formatt problem inESQL

« View previous topic :: View next topic »

Author

Message

raghug

Posted: Wed Oct 18, 2006 6:35 pm Post subject: CAST() time change formatt problem inESQL

Acolyte

Joined: 19 Jul 2006
Posts: 60
Location: NJ

Hi All
Please solue this problem I wrote this code for insert data into DB2 when trace this code thore expception ....what is the problem in this ..plz give my EXAMPL..

DECLARE TEMP_TIMEOFUPDATE CHARACTER;
SET TEMP_TIMEOFUPDATE = InputRoot.MRM.WTRK_TRAN.WTRK_HDR.STATUS_UPD_REC.TIME_OF_UPDATE;
DECLARE TIMEOF_UPDATE TIME;
DECLARE Pattern1 CHARACTER 'hh.mm.ss';
SET TIMEOF_UPDATE = CAST(TEMP_TIMEOFUPDATE AS TIME FORMAT Pattern);

Posted: Wed Oct 18, 2006 9:10 pm Post subject:

Partisan

Joined: 20 Sep 2005
Posts: 302
Location: Houston

Are you getting any error when you tried this code? If so, please post the error.

What is the data type of TIME_OF_UPDATE in the message set? If it is defined as anything other then STRING, then while casting to CHAR in ESQL, it will have the data type before the actual value. For example, if the data type is TIMESTAMP in the message set, then when you assign to a CHAR variable in ESQL, the value will be

TIMESTAMP '2006-10-19 00:00:00'

You need to do SUBSTRING to get only the value.

Regards,
VK.

raghug

Posted: Thu Oct 19, 2006 5:27 am Post subject: THIS The Error I got when i trace

Acolyte

Joined: 19 Jul 2006
Posts: 60
Location: NJ

(0x01000013):WTRK_TRAN = (
(0x01000013):WTRK_HDR = (
(0x01000013):CNTL_REC = (
(0x0300000B):CNTL_PARTNERID = 'DWS '
(0x0300000B):CNTL_PARTNERQUALIFER = ' '
(0x0300000B):CNTLIDENTIFIER = 'T'
(0x0300000B):CNTL_NUMBER = ' '
(0x0300000B):CNTL_TESTIND = ' '
(0x0300000B):CNTL_TRANTYPE = '214 '
(0x0300000B):CNTL_FUNCGROUP = 'QM '
(0x0300000B):CNTL_FILLER = ' '
)
(0x01000013):STATUS_UPD_REC = (
(0x0300000B):PRONUM = '102390391'
(0x0300000B):LINENUM = '074'
(0x0300000B):MOVENO = '01'
(0x0300000B):DATE_OF_UPDATE = '2006-10-05'
(0x0300000B):TIME_OF_UPDATE = '23.47.33'
(0x0300000B):NOTIFY1_TYPE = '214'
(0x0300000B):NOTIFY1 = ' '
(0x0300000B):NOTIFY1_FAXNUM = ' '
(0x0300000B):NOTIFY2_TYPE = ' '
(0x0300000B):NOTIFY2 = ' '
(0x0300000B):NOTIFY2_FAXNUM = ' '
(0x0300000B):REFNUM = 'CHS060918852 '
(0x0300000B):IEDPIND = 'I'
(0x0300000B):SCAC = 'BTTM'
(0x0300000B):ORIG_SHIP_STATUS = '00'
(0x0300000B):BOOKING_IND = 'I '
(0x0300000B):BOOKBLNO = '800086596 '
(0x0300000B):FREE_TEXT = ' '
(0x0300000B):BILLTO_NAME = 'MAERSK LINE MAD INTERMODAL '
(0x0300000B):BILLTO_ADDR1 = 'PO BOX 1992 '
(0x0300000B):BILLTO_ADDR2 = '465 SOUTH ST '
(0x0300000B):BILLTO_CITY = 'MORRISTOWN '
(0x0300000B):BILLTO_STATE = 'NJ'
(0x0300000B):BILLTO_ZIP = '07962 '
(0x0300000B):PUNAME = 'MAERSK LINE CHS '
(0x0300000B):PUADDR1 = 'LONG POINT RD. '
(0x0300000B):PUADDR2 = 'WANDO TERMINAL 843-881-3890 '
(0x0300000B):PUCITY = 'MOUNT PLEASANT '
(0x0300000B):PUSTATE = 'SC'
(0x0300000B):PUZIP = '29464 '
(0x0300000B):DELNAME = 'FREIGHTLINER CORP '
(0x0300000B):DELADDR1 = '552 HYATT STREET '
(0x0300000B):DELADDR2 = 'NANCY 864-206-8633 '
(0x0300000B):DELCITY = 'GAFFNEY '
(0x0300000B):DELSTATE = 'SC'
(0x0300000B):DELZIP = '29341 '
(0x0300000B):QSTAT_UPD_IND = 'AP'
(0x0300000B):QSTAT_UPD_DATE = '10/05/06'
(0x0300000B):QSTAT_UPD_TIME = '19.46.01'
(0x0300000B):LOCAL_TIME = 'LC'
(0x0300000B):DEL_PICKUP_CITY = 'MOUNT PLEASANT '
(0x0300000B):DEL_PICKUP_STATE = 'SC'
(0x0300000B):EQPNO1_INIT = 'MSKU'
(0x0300000B):EQPNO1_LAST = '8521633'
(0x0300000B):EQPNO2_INIT = ' '
(0x0300000B):EQPNO2_LAST = ' '
(0x0300000B):LOC_PHONENUM = '843-881-3894'
(0x0300000B):LOC_FAX = '843-881-2079'
(0x0300000B):LOC_TELEXADDR = 'CHSBTT '
(0x0300000B):LOC_TELEXSEC = 'WRL'
(0x0300000B):CURRENT_POS = 'MAE000'
(0x0300000B):STEAMSHIP_SCAC = 'MAEU'
(0x0300000B):UNIQUE_ID = '3U6NW92XTCMT5'
(0x0300000B):Status_Upd_FILLER = ' '
)
)
)
)

(
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S000_P\src\DataFlowEngine\ImbDataFlowNode.cpp'
(0x03000000):Line = 616
(0x03000000):Function = 'ImbDataFlowNode::createExceptionList'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'WRKT_MappMesgFlow#FCMComposite_1_3'
(0x03000000):Label = 'WRKT_MappMesgFlow.Compute'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Node throwing exception'
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp'
(0x03000000):Line = 589
(0x03000000):Function = 'SqlStatementGroup::execute'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'WRKT_MappMesgFlow#FCMComposite_1_3'
(0x03000000):Label = 'WRKT_MappMesgFlow.Compute'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2488
(0x03000000):Text = 'Error detected, rethrowing'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '.WRKT_MappMesgFlow_Compute.Main'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '27.9'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'SET TIMEOF_UPDATE = CAST(TEMP_TIMEOFUPDATE AS GMTTIME FORMAT Pattern2);'
)
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlTypeCast.cpp'
(0x03000000):Line = 257
(0x03000000):Function = 'SqlTypeCast::evaluate'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2521
(0x03000000):Text = 'Error while casting'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '.WRKT_MappMesgFlow_Compute.Main'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '27.29'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = ''23.47.33''
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'GMTTIME'
)
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S000_P\src\CommonServices\ImbTimeStampFormatter.cpp'
(0x03000000):Line = 1221
(0x03000000):Function = 'ImbTimeStampFormatter::subParse'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 3204
(0x03000000):Text = 'Hour value out of range (1-12)'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '23.47.33'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'hh:mm:ss'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '23'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'hh'
)
)
)
)
)
)
(
(0x01000000):Properties = (
(0x03000000):MessageSet = 'E3J4D94002001'
(0x03000000):MessageType = 'WTRK_MSG'
(0x03000000):MessageFormat = 'TDS1'
(0x03000000):Encoding = 546
(0x03000000):CodedCharSetId = 1208
(0x03000000):Transactional = TRUE
(0x03000000):Persistence = FALSE
(0x03000000):CreationTime = GMTTIMESTAMP '2006-10-18 22:19:32.600'
(0x03000000):ExpirationTime = -1
(0x03000000):Priority = 0
(0x03000000):ReplyIdentifier = X'000000000000000000000000000000000000000000000000'
(0x03000000):ReplyProtocol = 'MQ'
(0x03000000):Topic = NULL
(0x03000000):ContentType = ''
)
(0x01000000):MQMD = (
(0x03000000):SourceQueue = 'CODS.FEED'
(0x03000000):Transactional = TRUE
(0x03000000):Encoding = 546
(0x03000000):CodedCharSetId = 1208
(0x03000000):Format = 'MQSTR '
(0x03000000):Version = 2
(0x03000000):Report = 0
(0x03000000):MsgType = 8
(0x03000000):Expiry = -1
(0x03000000):Feedback = 0
(0x03000000):Priority = 0
(0x03000000):Persistence = 0
(0x03000000):MsgId = X'414d51207131202020202020202020205191364520010a02'
(0x03000000):CorrelId = X'000000000000000000000000000000000000000000000000'
(0x03000000):BackoutCount = 0
(0x03000000):ReplyToQ = ' '
(0x03000000):ReplyToQMgr = 'q1 '
(0x03000000):UserIdentifier = 'HANUG '
(0x03000000):AccountingToken = X'16010515000000351dbd6f0e8bfb9fd180a840f103000000000000000000000b'
(0x03000000):ApplIdentityData = ' '
(0x03000000):PutApplType = 11
(0x03000000):PutApplName = '30\eclipse\jre\bin\javaw.exe'
(0x03000000):PutDate = DATE '2006-10-18'
(0x03000000):PutTime = GMTTIME '22:19:32.600'
(0x03000000):ApplOriginData = ' '
(0x03000000):GroupId = X'000000000000000000000000000000000000000000000000'
(0x03000000):MsgSeqNumber = 1
(0x03000000):Offset = 0
(0x03000000):MsgFlags = 0
(0x03000000):OriginalLength = -1
)
(0x0100001B):MRM = (
(0x01000013):WTRK_TRAN = (
(0x01000013):WTRK_HDR = (
(0x01000013):CNTL_REC = (
(0x0300000B):CNTL_PARTNERID = 'DWS '
(0x0300000B):CNTL_PARTNERQUALIFER = ' '
(0x0300000B):CNTLIDENTIFIER = 'T'
(0x0300000B):CNTL_NUMBER = ' '
(0x0300000B):CNTL_TESTIND = ' '
(0x0300000B):CNTL_TRANTYPE = '214 '
(0x0300000B):CNTL_FUNCGROUP = 'QM '
(0x0300000B):CNTL_FILLER = ' '
)
(0x01000013):STATUS_UPD_REC = (
(0x0300000B):PRONUM = '102390391'
(0x0300000B):LINENUM = '074'
(0x0300000B):MOVENO = '01'
(0x0300000B):DATE_OF_UPDATE = '2006-10-05'
(0x0300000B):TIME_OF_UPDATE = '23.47.33'
(0x0300000B):NOTIFY1_TYPE = '214'
(0x0300000B):NOTIFY1 = ' '
(0x0300000B):NOTIFY1_FAXNUM = ' '
(0x0300000B):NOTIFY2_TYPE = ' '
(0x0300000B):NOTIFY2 = ' '
(0x0300000B):NOTIFY2_FAXNUM = ' '
(0x0300000B):REFNUM = 'CHS060918852 '
(0x0300000B):IEDPIND = 'I'
(0x0300000B):SCAC = 'BTTM'
(0x0300000B):ORIG_SHIP_STATUS = '00'
(0x0300000B):BOOKING_IND = 'I '
(0x0300000B):BOOKBLNO = '800086596 '
(0x0300000B):FREE_TEXT = ' '
(0x0300000B):BILLTO_NAME = 'MAERSK LINE MAD INTERMODAL '
(0x0300000B):BILLTO_ADDR1 = 'PO BOX 1992 '
(0x0300000B):BILLTO_ADDR2 = '465 SOUTH ST '
(0x0300000B):BILLTO_CITY = 'MORRISTOWN '
(0x0300000B):BILLTO_STATE = 'NJ'
(0x0300000B):BILLTO_ZIP = '07962 '
(0x0300000B):PUNAME = 'MAERSK LINE CHS '
(0x0300000B):PUADDR1 = 'LONG POINT RD. '
(0x0300000B):PUADDR2 = 'WANDO TERMINAL 843-881-3890 '
(0x0300000B):PUCITY = 'MOUNT PLEASANT '
(0x0300000B):PUSTATE = 'SC'
(0x0300000B):PUZIP = '29464 '
(0x0300000B):DELNAME = 'FREIGHTLINER CORP '
(0x0300000B):DELADDR1 = '552 HYATT STREET '
(0x0300000B):DELADDR2 = 'NANCY 864-206-8633 '
(0x0300000B):DELCITY = 'GAFFNEY '
(0x0300000B):DELSTATE = 'SC'
(0x0300000B):DELZIP = '29341 '
(0x0300000B):QSTAT_UPD_IND = 'AP'
(0x0300000B):QSTAT_UPD_DATE = '10/05/06'
(0x0300000B):QSTAT_UPD_TIME = '19.46.01'
(0x0300000B):LOCAL_TIME = 'LC'
(0x0300000B):DEL_PICKUP_CITY = 'MOUNT PLEASANT '
(0x0300000B):DEL_PICKUP_STATE = 'SC'
(0x0300000B):EQPNO1_INIT = 'MSKU'
(0x0300000B):EQPNO1_LAST = '8521633'
(0x0300000B):EQPNO2_INIT = ' '
(0x0300000B):EQPNO2_LAST = ' '
(0x0300000B):LOC_PHONENUM = '843-881-3894'
(0x0300000B):LOC_FAX = '843-881-2079'
(0x0300000B):LOC_TELEXADDR = 'CHSBTT '
(0x0300000B):LOC_TELEXSEC = 'WRL'
(0x0300000B):CURRENT_POS = 'MAE000'
(0x0300000B):STEAMSHIP_SCAC = 'MAEU'
(0x0300000B):UNIQUE_ID = '3U6NW92XTCMT5'
(0x0300000B):Status_Upd_FILLER = ' '
)
)
)
)
)

(
(0x01000013):WTRK_TRAN = (
(0x01000013):WTRK_HDR = (
(0x01000013):CNTL_REC = (
(0x0300000B):CNTL_PARTNERID = 'DWS '
(0x0300000B):CNTL_PARTNERQUALIFER = ' '
(0x0300000B):CNTLIDENTIFIER = 'T'
(0x0300000B):CNTL_NUMBER = ' '
(0x0300000B):CNTL_TESTIND = ' '
(0x0300000B):CNTL_TRANTYPE = '214 '
(0x0300000B):CNTL_FUNCGROUP = 'QM '
(0x0300000B):CNTL_FILLER = ' '
)
(0x01000013):STATUS_UPD_REC = (
(0x0300000B):PRONUM = '102390391'
(0x0300000B):LINENUM = '074'
(0x0300000B):MOVENO = '01'
(0x0300000B):DATE_OF_UPDATE = '2006-10-05'
(0x0300000B):TIME_OF_UPDATE = '23.47.33'
(0x0300000B):NOTIFY1_TYPE = '214'
(0x0300000B):NOTIFY1 = ' '
(0x0300000B):NOTIFY1_FAXNUM = ' '
(0x0300000B):NOTIFY2_TYPE = ' '
(0x0300000B):NOTIFY2 = ' '
(0x0300000B):NOTIFY2_FAXNUM = ' '
(0x0300000B):REFNUM = 'CHS060918852 '
(0x0300000B):IEDPIND = 'I'
(0x0300000B):SCAC = 'BTTM'
(0x0300000B):ORIG_SHIP_STATUS = '00'
(0x0300000B):BOOKING_IND = 'I '
(0x0300000B):BOOKBLNO = '800086596 '
(0x0300000B):FREE_TEXT = ' '
(0x0300000B):BILLTO_NAME = 'MAERSK LINE MAD INTERMODAL '
(0x0300000B):BILLTO_ADDR1 = 'PO BOX 1992 '
(0x0300000B):BILLTO_ADDR2 = '465 SOUTH ST '
(0x0300000B):BILLTO_CITY = 'MORRISTOWN '
(0x0300000B):BILLTO_STATE = 'NJ'
(0x0300000B):BILLTO_ZIP = '07962 '
(0x0300000B):PUNAME = 'MAERSK LINE CHS '
(0x0300000B):PUADDR1 = 'LONG POINT RD. '
(0x0300000B):PUADDR2 = 'WANDO TERMINAL 843-881-3890 '
(0x0300000B):PUCITY = 'MOUNT PLEASANT '
(0x0300000B):PUSTATE = 'SC'
(0x0300000B):PUZIP = '29464 '
(0x0300000B):DELNAME = 'FREIGHTLINER CORP '
(0x0300000B):DELADDR1 = '552 HYATT STREET '
(0x0300000B):DELADDR2 = 'NANCY 864-206-8633 '
(0x0300000B):DELCITY = 'GAFFNEY '
(0x0300000B):DELSTATE = 'SC'
(0x0300000B):DELZIP = '29341 '
(0x0300000B):QSTAT_UPD_IND = 'AP'
(0x0300000B):QSTAT_UPD_DATE = '10/05/06'
(0x0300000B):QSTAT_UPD_TIME = '19.46.01'
(0x0300000B):LOCAL_TIME = 'LC'
(0x0300000B):DEL_PICKUP_CITY = 'MOUNT PLEASANT '
(0x0300000B):DEL_PICKUP_STATE = 'SC'
(0x0300000B):EQPNO1_INIT = 'MSKU'
(0x0300000B):EQPNO1_LAST = '8521633'
(0x0300000B):EQPNO2_INIT = ' '
(0x0300000B):EQPNO2_LAST = ' '
(0x0300000B):LOC_PHONENUM = '843-881-3894'
(0x0300000B):LOC_FAX = '843-881-2079'
(0x0300000B):LOC_TELEXADDR = 'CHSBTT '
(0x0300000B):LOC_TELEXSEC = 'WRL'
(0x0300000B):CURRENT_POS = 'MAE000'
(0x0300000B):STEAMSHIP_SCAC = 'MAEU'
(0x0300000B):UNIQUE_ID = '3U6NW92XTCMT5'
(0x0300000B):Status_Upd_FILLER = ' '
)
)
)
)

(
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S000_P\src\DataFlowEngine\ImbDataFlowNode.cpp'
(0x03000000):Line = 616
(0x03000000):Function = 'ImbDataFlowNode::createExceptionList'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'WRKT_MappMesgFlow#FCMComposite_1_3'
(0x03000000):Label = 'WRKT_MappMesgFlow.Compute'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2230
(0x03000000):Text = 'Node throwing exception'
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlStatementGroup.cpp'
(0x03000000):Line = 589
(0x03000000):Function = 'SqlStatementGroup::execute'
(0x03000000):Type = 'ComIbmComputeNode'
(0x03000000):Name = 'WRKT_MappMesgFlow#FCMComposite_1_3'
(0x03000000):Label = 'WRKT_MappMesgFlow.Compute'
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2488
(0x03000000):Text = 'Error detected, rethrowing'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '.WRKT_MappMesgFlow_Compute.Main'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '27.9'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'SET TIMEOF_UPDATE = CAST(TEMP_TIMEOFUPDATE AS TIME FORMAT Pattern2);'
)
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S000_P\src\DataFlowEngine\ImbRdl\ImbRdlTypeCast.cpp'
(0x03000000):Line = 257
(0x03000000):Function = 'SqlTypeCast::evaluate'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 2521
(0x03000000):Text = 'Error while casting'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '.WRKT_MappMesgFlow_Compute.Main'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '27.29'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = ''23.47.33''
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'TIME'
)
(0x01000000):RecoverableException = (
(0x03000000):File = 'F:\build\S000_P\src\CommonServices\ImbTimeStampFormatter.cpp'
(0x03000000):Line = 1221
(0x03000000):Function = 'ImbTimeStampFormatter::subParse'
(0x03000000):Type = ''
(0x03000000):Name = ''
(0x03000000):Label = ''
(0x03000000):Catalog = 'BIPv600'
(0x03000000):Severity = 3
(0x03000000):Number = 3204
(0x03000000):Text = 'Hour value out of range (1-12)'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '23.47.33'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'hh.mm.ss'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '23'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'hh'
)
)

jefflowrey

Posted: Thu Oct 19, 2006 5:35 am Post subject: Re: THIS The Error I got when i trace

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

raghug wrote:

(0x03000000):Text = 'Hour value out of range (1-12)'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '23.47.33'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'hh.mm.ss'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = '23'
)
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'hh'
)
)

http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r0m0/topic/com.ibm.etools.mft.doc/ak05616_.htm

Quote:

h hour in am or pm (1-12) Number 6
hh hour in am or pm (01-12) Number 06
H hour of day in 24 hour form (0-23) Number 77
HH hour of day in 24 hour form (00-23) Number 07

_________________
I am *not* the model of the modern major general.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » CAST() time change formatt problem inESQL

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