Re: [Openinteract-dev] anyone knowledgable about cross-platform datatypes?

[Andrew H. <hu...@ll...>]

At 11:49 AM 1/6/2003 -0500, you wrote:
>Andrew Hurst wrote:
>...
>>special cases for it.  What might be worse is the date/time formatting, I 
>>doubt that it's standardized.
>
>Date/time formatting is *MUCH* worse, but fortunately that can be dealt 
>with almost entirely within the application logic. Someone else's problem :-)

Forgive me if I'm asking an obvious question, as I haven't actually gotten 
OI running on my machine here yet, but how will this work?  Will you set it 
up so that no matter what the database it returns the date in a standard 
format?  like DD-MM-YYYY HH:MI:SS, then require the app to format it as 
necessary...   Will there be a set of routines for formatting it 
built-in?  I've used Date::Calc and Date::Format before and they worked 
rather well, thought I'm not sure about speed/size (never had the need to 
check on them before).

I could see the db driver always returning it in the same format, then 
requiring it to be input in the same format as well.  Maybe a 
format_for_db() function, taking the format you currently have the date in 
and the date, and it returning the string formatted for what the driver 
expects...

Anyway, thats my rambling thoughts.  Is that what you meant above?

-Andrew


>Chris
>
>--
>Chris Winters (ch...@cw...)
>Building enterprise-capable snack solutions since 1988.