How to Create View and show datetime format?

[Former user]

Originally reported on Google Code with ID 233

What steps will reproduce the problem?
1.I create view using this tab "Create new view on database" but it show me an error
message: "ERROR: near " ": syntax error....."
2. How to show datetime format from a value in INTEGER field: 1380230349
3.

What is the expected output? What do you see instead?

I'm using version: phpliteadmin v1.9.4.1
OS: Linux

Reported by phuongpm on 2013-09-27 10:11:22

[Christopher Kramer]

Sorry for the very late reply.
1. What did you enter as the SELECT statement for your view? The syntax error is likely
to be in there.
2. I do not understand what you mean here.

I do not see any defect here. Please clarify what your problem is.

Reported by crazy4chrissi on 2013-12-23 23:29:54

[Christopher Kramer]

I think you did not report a defect but ask for help.

This is not the place to do so. You might use the mailing list:
https://groups.google.com/forum/#!forum/phpliteadmin
We don't teach SQL or SQlite here. Read the SQLite documentation for example:
https://www.sqlite.org/docs.html

Reported by crazy4chrissi on 2013-12-26 00:10:50 - Status changed: Invalid

[Former user]

All my problems was solved a long time ago.
Thanks for your responding!

Reported by phuongpm on 2013-12-26 08:22:51