||Re: date conversion for mysql
Akshat Kapoor <email@example.com>
||Thu, 10 Jan 2019 18:52:25 +0530
On 10/01/2019 15:06, Charlie wrote:
> Hi.. Is there an easy way to convert a date field to this format?
> It could be a character string result also.....
> I believe the dashes have to be there....
> Thanks much for any help!
It will depend upon which database you are using.
With MariaDb I use dtos() and wrap it in quotes.
"20190110" as part of sql statement works very well to represent the date.
Give this a try. If it fails then you always have Mervyn's function.
It is just a coincidence that I started using dtos() on Mervyn's
suggestion. As the value returned is independent of the system date format.