Re: Integrating date and time parsing and formatting

2003-01-21 Thread Matt Sergeant
On Tue, 21 Jan 2003, John Siracusa wrote: On 1/21/03 3:38 AM, H.Merijn Brand wrote: FWIW *if* there should be a default date format for DBI, *please* make it universal: MMDD and not MMDD or MM/DD/, because you have no idea how much irritation this arouses in European countries.

Re: Integrating date and time parsing and formatting

2003-01-21 Thread John Siracusa
On 1/21/03 11:04 AM, John Siracusa wrote: On 1/21/03 10:52 AM, Matt Sergeant wrote: Does this cover DBD's (like mine) that don't support *any* data types? Sure. If you really make no distinctions about data types, then you'd probably just make the methods no-op pass-throughs for the data.

Re: Integrating date and time parsing and formatting

2003-01-21 Thread Dave Rolsky
On Tue, 21 Jan 2003, John Siracusa wrote: On 1/21/03 3:38 AM, H.Merijn Brand wrote: FWIW *if* there should be a default date format for DBI, *please* make it universal: MMDD and not MMDD or MM/DD/, because you have no idea how much irritation this arouses in European countries.

Re: Integrating date and time parsing and formatting

2003-01-21 Thread Dave Rolsky
On Tue, 21 Jan 2003 [EMAIL PROTECTED] wrote: Let me put in a plug for separate DATE and DATETIME types. I don't know whether the datetime list has discussed this, and the last time I tried to join the list, I kept getting some weird error. Dates are like the integers. Datetimes are like

Re: Integrating date and time parsing and formatting

2003-01-21 Thread Dave Rolsky
On Tue, 21 Jan 2003, Dave Rolsky wrote: This should probably be discussed on the DateTime.pm list. Uh, that'd be [EMAIL PROTECTED] There is no DateTime.pm list. I'm losing my mind. -dave /*=== House Absolute Consulting www.houseabsolute.com ===*/

Re: Integrating date and time parsing and formatting

2003-01-21 Thread John . Tobey
Let me put in a plug for separate DATE and DATETIME types. I don't know whether the datetime list has discussed this, and the last time I tried to join the list, I kept getting some weird error. Dates are like the integers. Datetimes are like the real numbers. The existence of timezones and

Re: Integrating date and time parsing and formatting

2003-01-21 Thread Tim Bunce
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. For typed placeholders: $sth-bind_param(1, 2002-01-21, SQL_DATE); $sth-bind_param(2, 17:45:23, SQL_TIME); $sth-bind_param(3,

Re: Integrating date and time parsing and formatting

2003-01-21 Thread Dave Rolsky
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

Re: Integrating date and time parsing and formatting

2003-01-21 Thread David Wheeler
On Tuesday, January 21, 2003, at 02:06 PM, Tim Bunce wrote: I'm not keen on having the DBI or drivers call methods when passed blessed references. I'd say the object should stringify to the standard ISO format or the uer calls the method explicitly: $sth-bind_params(1,

Re: Integrating date and time parsing and formatting

2003-01-21 Thread Michael Peppler
On Tue, 2003-01-21 at 14:25, David Wheeler wrote: Also, I'd love to get fetch() and such to optionally turn date and time and datetime fields into objects before returning them, too. Would such a thing be possible? Sybase::CTlib and Sybase::DBlib can do this - optionally creating a DateTime

Re: Integrating date and time parsing and formatting

2003-01-21 Thread David Wheeler
On Tuesday, January 21, 2003, at 02:34 PM, Michael Peppler wrote: Sybase::CTlib and Sybase::DBlib can do this - optionally creating a DateTime object that is in native Sybase format and can be cracked and manipulated with the Sybase API. It works, but the object creation for each fetched row is

Re: Integrating date and time parsing and formatting

2003-01-21 Thread Tom May
The best thing about standards is there are so many to choose them, or maybe it's that you don't really need to follow them (e.g., HTTP and HTML). ISO 8601 requires date and time to be separated by a 'T': 1998-05-12T14:15Z. Tom. Tim Bunce [EMAIL PROTECTED] writes: FWIW *if* there should be a

Re: [patch] making tests locale independent

2003-01-21 Thread Tim Bunce
Does that work on Windows? and Mac OS? and VMS? and ... Tim. On Tue, Jan 21, 2003 at 08:15:06PM +0100, Christian Hammers wrote: Hi Currently the regression tests fail when using a locale that produces something else than No such file or directory. Please apply the attached patch. bye,