Timestamp in column

QuestionsTimestamp in column
SaschaL asked 11 years ago

select_command = "SELECT FROM_UNIXTIME(`time`), `string` FROM `logs`";

How i'll get propper datetime-values in column formatted like this:

$col["formatter"] = "datetime";

In my example i'll get the values "undefined" in each row?

i use the free version of your awesome tool 🙂

Like it!

Kind regards

PS: Sorry for my bad english

1 Answers
SaschaL answered 11 years ago

– Given alias to column 'time'

"SELECT FROM_UNIXTIME(`time`) AS `Value`, `string` FROM `logs`"

– Use alias as ID in column

$col["name"] = "Value";

Works 🙂

Have a nice day!

Best Regards

Your Answer

20 + 0 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?