VFP 9 DateTime and MySQL
Posted on 2010-11-09
Hi all. I use VFP to connect to a MySQL db.
How would I insert into the db the value "11/9/2010" when the db field is set to DATETIME?
I'm assuming a FP function will be needed to append time as "00:00:00" in order for the field to accept it?
If so, how then would I retrieve the date from the db for use in a VFP form where only the date in 11/9/2010 format is required?
In short what I'm asking is what are the two FP functions to 1) convert the date to a DATETIME for insertion into the db, and 2) on retrieval, strip the time portion so only the date is left.