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 dates are returned as REAL numbers and generally
I would format it to suit the occasion, ie
formatdatetime('yyyy-mm-dd',myDate.value).
So, in mySQL
sql := 'INSERT INTO myTable SET myDate = ' + formatdatetime(datemask
,myDate.value);
Looking at the mySQL docs AFAI can work out datemask should be
yyyy-mm-dd but this doesn't work.
what is the expected 'datemask'? Or have I got wrong?
More importantly are there functions in mySQL I can call to convert a
standard date, ie "yyyymmdd" to the expected mySQL value?
Any help to get me over this confusing hump is appreciated.
--
Pierre du Parté
Final Filer Software
349 Worrigee Road
Worrigee, NSW, Australia 2540
http://www.finalfiler.com
Phone 61 2 44216374
Mobile 0413 483 066
"If it feels good, do it!"
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
