2. PHPRunner General questions
  3. DATETIME and SQLite
This topic is locked

DATETIME and SQLite

 		6/5/2014 11:23:49
PHPRunner General questions
P
 psciga author

Hello,
I'm using PHPRunner 7.0 (Build 19042) with SQLite. Please tell me how to use data type DATETIME in PHPR. In the editor I've tried to use "edit as"/"View as" date or time, but it is not possible (fields are deactivated). Here my test create statement:

CREATE TABLE "zeiten" ("zid" INTEGER PRIMARY KEY NOT NULL , "zeit1" DATETIME DEFAULT CURRENT_TIMESTAMP)


Thanks in advance!
Peter
P.S.: Sorry, I'm a beginner
Sergey Kornilov admin 6/5/2014

Looks like a bug in PHPRunner. The same behavior in version 7.1 as well. We'll see what we can do.
P
 		psciga author 6/6/2014

Hello Sergey,



We'll see what we can do.


Thanks for replay! So I'm looking forward hopeful.
Best regards
Peter
Sergey Kornilov admin 6/6/2014

Peter,
we can fix this in version 7.1. Please contact support team at http://support.xlinesoft.com sending your PHPRunner order number and we'll send you a custom build.