How to Create View and show datetime format?

[GoogleCodeExporter]

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

Original issue reported on code.google.com by phuon...@gmail.com on 27 Sep 2013 at 10:11

[GoogleCodeExporter]

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.

Original comment by crazy4ch...@gmail.com on 23 Dec 2013 at 11:29

[GoogleCodeExporter]

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

Original comment by crazy4ch...@gmail.com on 26 Dec 2013 at 12:10

• Changed state: Invalid

[GoogleCodeExporter]

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

Original comment by phuon...@gmail.com on 26 Dec 2013 at 8:22