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
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