On Tue, 21 Jan 2003, Tim Bunce wrote: > > FWIW *if* there should be a default date format for DBI, *please* ... > > *If* there should be a default date format for DBI it will be the ISO > standard used by ODBC.
I think there may be some confusion here. What _I_ had envisioned, if this were to come to pass, was not a standard format (like ISO), but a standard object. So we'd have something like this: $sth->bind_params(1, $datetime_object, SQL_DATE); Given a standard API, the driver would be able to call methods on this object to get a string in the format it needs, which will vary from DBMS to DBMS, most likely. Defining a standard datetime format for DBI/DBD is sort of orthogonal to this, though it may be a good idea as well, or instead of, what I'm thinking of. -dave /*======================= House Absolute Consulting www.houseabsolute.com =======================*/
