hallo i use VB6 - ADO 2.6 with the newest MyODBC with options 16834 even when make a select on a date or time type columne i get the windows-format 24.12.2001 , but the format is realy YYYY-MM-DD. So i get a lot of trouble...... what i have to do, that i get the right date/time-format(YYYY-MM-DD) ??????? ------database,sql,query