Re: [RFC] Date/Time standard for input/output

2002-08-04 Thread Matt Sergeant
ODBC has a built-in standard for this - I forget exactly what it is, but it's something like {d -MM-DD}, {t HH:MM:SS} and {ts -MM-DD HH:MM:SS} (for input, that is - I think output is still database specific, but I could be wrong). Alternatively, you could specify something like a Time

[RFC] Date/Time standard for input/output

2002-08-04 Thread Daniel Ritz
hi [please CC as i'm not on the list] DBI has a real problem: input/output of date/time/timestamp values. each driver handles it different. most of the drivers returns string, but all in a different format. this is where DBI should set a standard. in DBD-InterBase we now have a very flexible