Re: Convert date format

[Marius Kjeldahl <marius@...>]

I have no experience with this in lua, but as far as I know both Oracle and 
Mysql has functions that you can use in select statements that return the 
format in the format you want. From your example, it looks like lua just 
returns the string from the database anyway, which means using database 
functions for string formatting should work just fine.

Marius K.

marcoswur@yahoo wrote:
> Hi,
>
> I use LuaSQL to query a database.
> In case that the field is in date format, it return a string '2002-10-10
> 00:00:00'.
> I want to change the format for '10/10/02'.
> I can use strfind and strsub.
> The date() function could receive this string as parameter?
> It would be the ideal.
> a  = date('%d/%m/%y ', ' 2002-10-10 00:00:00 ')
> print(a) - > 10/10/02
>
> What is the best way to make this conversion?
> Or I can format LuaSQL to return the date in the desired format?
>
> Thanks