Database Connector with table having column Date

, ,
1

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

2

Hi,

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

Regards.