Subject Re: date conversion for mysql
From Mervyn Bick <invalid@invalid.invald>
Date Thu, 10 Jan 2019 12:16:33 +0200
Newsgroups dbase.getting-started

On 2019-01-10 11:36 AM, Charlie wrote:
> Hi.. Is there an easy way to convert a date field to this format?
> It could be a character string result also.....
> yyyy-mm-dd
> I believe the dashes have to be there....
> Thanks much for any help!

The following little function will convert a date to a string in the
format that MYSQL wants.  Remember that you need to wrap the string in
quotes if you are going to use it in a SQL statement.

If you want the string "Pre-wrapped" change the last line of the
function to

return "'"+yr+'-'+mn+'-'+da+"'"

? date2mysql(date())

function date2mysql(date)
    //accepts a date, returns a string
    yr = date.year
    mn = str(date.month+1,2,0,'0')
    da = str(,2,0,'0')
    return yr+'-'+mn+'-'+da