Valid timestamp format

abdulrafi · Posted: Thu May 30, 2013 9:34 pm Post subject: Valid timestamp format

Hi,

I would need a help on to identify if a field contains a valid timestamp format or not.

I do have a requirement where I get a timestamp value in a variable and I need to check if its in the correct format or not.

The actual timestamp format is fo 26 bytes: yyyy-MM-dd-HH.mm.ss.ffffff

Should I check if there is a '-' on 5th,8th,11th position and '.' in 14th,17th,20th position ?. Will it be the correct way to check it ??

Please advice.

Thanks
Abdul Rafi

dick scherrer · Posted: Thu May 30, 2013 9:42 pm Post subject:

Hello,

To be accurate/complete, you must test every part of the entire field. Merely checking the "-" and "." delimiters provides little value. . .

What about a month, day, hour, minute, second that are numeric, but invalid?

Same with year, and leap year.

Mickeydusaor · Posted: Thu May 30, 2013 9:46 pm Post subject:

wherre are you getting this timestamp from DB2..????

Pandora-Box · Posted: Thu May 30, 2013 9:59 pm Post subject:

Try to do a SET or SELECT FROM SYSDUMMY1 using the value you have

So you dont need to bother about source information

dick scherrer · Posted: Thu May 30, 2013 10:02 pm Post subject:

Yup, that will be ok if the code already uses DB2 . . .

d

Bill O'Boyle · Posted: Thu May 30, 2013 11:07 pm Post subject: Reply to: Valid timestamp format

The following previous post, shows the use of the Assembler TIME macro, returning a date-format of C'CCYYMMDD' and a time-format of C'HHMMSSTHMIJU', with "U" representing microseconds. If you don't have DB2, then this should suffice -

http://ibmmainframes.com/viewtopic.php?p=310291&highlight=#310291

dick scherrer · Posted: Thu May 30, 2013 11:29 pm Post subject:

Hi Bill,

I believe the TS wants to validate a timestamp that has arrived in the code . . .

Bill O'Boyle · Posted: Thu May 30, 2013 11:56 pm Post subject: Reply to: Valid timestamp format

Dick,

Sorry, blew right through that post's aspect

dick scherrer · Posted: Fri May 31, 2013 1:04 am Post subject:

Negative perspiration

Do that myself with some regularity

d

Bill O'Boyle · Posted: Fri May 31, 2013 2:37 am Post subject: Reply to: Valid timestamp format

You can verify the format as well as the contents by calling LE Callable Service routine "CEESECS".

http://pic.dhe.ibm.com/infocenter/ratdevz/v7r5/index.jsp?topic=%2Fcom.ibm.etools.cbl.win.doc%2Ftopics%2Frpsrv36.htm

A value returned by "CEESECS", in the first two-bytes of the 12-byte "Feedback Code" parameter, which is not X'00's should be considered an error.

HTH....