Dear Ranjan BANERJI, I would like to thank you for your reply but I feel that I have to exemplify my problem a bit more: I am able to extract the date portion from the user-supplied date but I am not able to do the same for the date retrieved from the database. What I need is the name of the SQL function that does this. Thank you for your time, Christos P.:)

This may depend on the version of the OS and/or the version of the ODBC driver... but check to see if you can set the buffer size. I think I ran into something like when moving one of my application to ME and I may have been moving to a newer ODBC driver at the same time (sorry I don't have details on version number just now). Anyway I think there was something that set the buffer to 1024 and I changed it to 256 (or something like that).