Re: HELP - Insight into dates, please

2002-05-19 Thread Pierre du Parte
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

Re: HELP - Insight into dates, please

2002-05-19 Thread Richard Clarke
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]>

HELP - Insight into dates, please

2002-05-19 Thread Pierre du Parte
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