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.



#Automation


#Applicationintegration
#webMethods
#Integration
 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 09/25/12 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 11/12/12 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