Many thanks for the, Richard...
You wrote:
>
> I'm not so sure what you are asking here but from this statement,
>
> More importantly are there functions in mySQL I can call to convert a
> standard date, ie "mmdd" to the expected mySQL value?.
Yeah, I was a bit vague :-) But your exa
l the above should work though I'm not 100% sure on the * marked ones and
I don't have time to test.
Ric.
p.s. This should work with timestamp typed columns too. I think?
- Original Message -
From: "Pierre du Parte" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Excuse this old ACCESS/ CLARION hack for asking such a basic question,
but the mySQL docs have given me a head-ache :-)
I want to move an ACCESS database to mySQL. I am writing the Code in Delphi.
My problem is assigning the date values in the SQL INSERT INTO string.
In the system I'm using da