Skip to Main Content
IBM Z Software


This portal is to open public enhancement requests against IBM Z Software products. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Delivered
Workspace PL/I Compilers
Created by Guest
Created on Jul 13, 2016

validdate(..) shall support more formats

This is a followup of RFE 90939.

I kindly ask for additional formats support of validdate(<variable>, <format>).

You asked for a list of formats, currently i only need the db2 timestamp format as i want to check a timestamp before i use it with a db2 sql (so avoid the sql to fail because the timestamp is malformed).
I request "yyyy-mm-dd hh:mi:ss.999999" - maybe there are variants - your db2 guys should know it better than me :-).
Currently i've written my own routine, see below.

br johann

Appendix: My own routine
validts: proc(ts) returns(type boolean);
dcl ts char(26) nonassignable;
dcl 1 ts_ based(addr(ts)),
2 date char(10),
2 fil1 char(1),
2 hh char(2),
2 fil2 char(1),
2 mi char(2),
2 fil3 char(1),
2 ss char(2),
2 fil4 char(1),
2 ts char(6);

if ^validdate(ts_.date, 'YYYY-MM-DD') then return(false);

if ^between(ts_.hh, '00','23')
! ^between(ts_.mi, '00','59')
! ^between(ts_.ss, '00','59')
! ^between(ts_.ts, '','999999')
! ts_.ts <> trim(ts_.ts)
then return(false);

if ts_.fil1 !! ts_.fil2 !! ts_.fil3 !! ts_.fil4 <> ' ::.'
then return(false);

return(true);

end validts;
Appendix: Reference validdate: http://www.ibm.com/support/knowledgecenter/SSY2VQ_3.1.0/com.ibm.aix.pli.doc/LR/dtbifs.htm

Idea priority Medium
  • Guest
    Reply
    |
    Jan 31, 2017

    This was delivered as part of APAR PI75582 / PTF UI44364

    'YYYY-MM-DD HH:MI:SS.999999' is now a fully-supported time pattern

    this also requires the appropriate PTFs for library APARs PI66445 & PI67787

  • Guest
    Reply
    |
    Jul 17, 2016

    Support for the ISO8601 format, see , might also be a useful addition.

  • Guest
    Reply
    |
    Jul 14, 2016

    this would be useful; if other users want other specific patterns, it will be easy to satisfy any RFE's requesting them