[Gambas-user] MySQL, $Query = "SELECT CURTIME()"

[Jesus]

El 23/09/12 09:39, abbat escribió:
>
> Hi,
>
> I cant get how to get current time.
>
> In tutorial is clear example to get var from Query using name of Query:
>
>   $Phone = $Result!Phone
>
> But how to get Result if my Query is
> $Query = "SELECT CURTIME()"
>
> And, how to trasform that result to date format
>
> Thanks .
>

May be this helps, though I haven't tested it:

$Query = "SELECT CURTIME() AS ctime"

$mytime = $Result!ctime

And for the formatting issue, you might look at the gambas wiki manual:

http://www.gambasdoc.org/help/lang/format

http://www.gambasdoc.org/help/cat/userformat



Regards
-- 
Jesus Guardon