Categories > TinyButStrong general >

UNIX_TIMESTAMP in mySql queery

The forum is closed. Please use Stack Overflow for submitting new questions. Use tags: tinybutstrong , opentbs
By: Quzi
Date: 2003-05-11
Time: 05:59

UNIX_TIMESTAMP in mySql queery

I am be trying queery in mySQL but is no work. It gets lastlogin and puts it in last, but no converting is be done. If I doing this in regular program is works, but when trying in TBS is no work.

Here is what I is done:

$query = "SELECT *, UNIX_TIMESTAMP(lastlogin) as last FROM users order by userid";

$RecCnt = $ObjTBS->MergeBlock("blk", $cnx_id, $query, $PageSize, $PageNum, $RecCnt) ;

Thanking you with flipping toes.

Quzi
By: Skrol29
Date: 2003-05-11
Time: 11:07

Re: UNIX_TIMESTAMP in mySql queery

Hello Quzi,

It works fine for me.
What happens for you?

By: Quzi
Date: 2003-05-12
Time: 20:05

Re: UNIX_TIMESTAMP in mySql queery

Is OK now I thinking. Not know what was prededing trouble.

You are greatfully to helping me.