U++ framework: U++ SQL » [sqlite] SqlCurrentTime is inconsistent with TIME definition

Home » U++ Library support » U++ SQL » [sqlite] SqlCurrentTime is inconsistent with TIME definition

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

[sqlite] SqlCurrentTime is inconsistent with TIME definition [message #47439]

Mon, 16 January 2017 22:25

Zbych
Messages: 332
Registered: July 2009

Senior Member

Hi,

TIME in sqlite is defined as "datetime", but SqlCurrentTime is just "time('now')", not "datetime('now')", so when I insert/update TIME field I got only hour without date.

Sqlite3Schema.h:
#define TIME(x)                    COLUMN("datetime", Time, x, 0, 0)

SqlVal.cpp:
SqlVal SqlCurrentTime() {
	return SqlVal(SqlCode(SQLITE3, "time('now')")
	                     ("current_timestamp"), SqlVal::HIGH);
}

[Updated on: Mon, 16 January 2017 22:28]

Report message to a moderator