Página 1 de 1

How to use date functions for SQLite

Publicado: Mar Sep 17, 2013 6:07 am
por Dionisis Divaris
Hello to all
What is the way to use the date functions like:
local_timestamp()
crod(cdate)
quarter()
concat() etc..
For intance when i use ctode("13/09/2013") return the coresponding date value not numeric as required by SQLite.
The fuctions local_timestamp(), quarter(), concat() give me undefined references to them durring linking.
What doing wrong.

How to use date functions for SQLite

Publicado: Mar Sep 17, 2013 1:44 pm
por ignacio
Dionisis Divaris escribió el mar, 17 septiembre 2013 06:07Hello to all
What is the way to use the date functions like:
local_timestamp()
crod(cdate)
quarter()
concat() etc..
For intance when i use ctode("13/09/2013") return the coresponding date value not numeric as required by SQLite.
The fuctions local_timestamp(), quarter(), concat() give me undefined references to them durring linking.
What doing wrong.

Those functions should be used only on SELECT statements. BTW take a look at the property oSqliteDataSource:lDateAsString.
Regards