i have a problem to manipulate the datetime in informix. in the user interface, the textbox do the work for me in the format dd/mm/yyyy. when i use the executesql of adodb, the format for driver is yyyy-mm-dd hh:mm:ss. the informix setnet32 have the datetime set to %d/%m/%Y %H:%M:%S. there is a mode to have a standard manipulation of data format?