||Re: date conversion for mysql
||Thu, 10 Jan 2019 22:57:19 -0500
Hi Mervyn... Thanks.. I'll try that. I came up with one for xdml although it isn't tested. Think this will work?
datestring = dtos(date())
yearstr = year(date())
monthstr = month(date())
if monthstr < 10
monthstr = "0"+ monthstr
daystr = day(date())
if daystr < 10
daystr = "0" + daystr
datestring = "'"+yearstr+"-"+monthstr+"-"+daystr+"'"
msgbox( datestring )
Mervyn Bick Wrote:
> 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(date.date,2,0,'0')
> return yr+'-'+mn+'-'+da