[AccessD] That SQL date catch again

Gustav Brock gustav at cactus.dk
Thu Jul 8 14:05:50 CDT 2004


Hi Susan

> I've heard you guys discuss the SQL behavior that uses the US standard for
> date strings, which causes non-US developers trouble if they don't know
> about it. 
 
> My question is:
 
> Is this a problem only when passing a date "string" or is the same true if
> you pass a date data type. I would think SQL should be able to process a
> date value passed by a date data type correctly. 
 
> I haven't tested anything -- looking for a place to start.

The issue exists when building SQL in code inserting one or more
parameters as date/time. I guess this is what you are thinking of.

For handling fields of date/time type I have experienced no problems.

/gustav




More information about the AccessD mailing list