IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

Database Connector with table having column Date

  • 1.  Database Connector with table having column Date

    Posted Tue September 25, 2012 10:44 AM

    Hello Team,

    I have just started with CAF development.

    I am having an issue when creating a database connector with a table which has a column of type Date (MS SQL server 2008). The columns having datatype date are being skipped.

    Do you know how I can handle this situation as I would like to do update delete and add on this table?

    Thanking you in advance for your cooperation.

    Kind Regards,
    Lutchumaya


    #webMethods-BPMS
    #webMethods
    #MWS-CAF-Task-Engine


  • 2.  RE: Database Connector with table having column Date

    Posted Mon November 12, 2012 11:23 AM

    Hi,

    try to use this date format (yyyy-MM-dd HH:mm:ss) in your sql command.

    Regards.


    #webMethods-BPMS
    #webMethods
    #MWS-CAF-Task-Engine


Related Content