Android Question convert datevalue in the db query

Roberto P.

Well-Known Member
Licensed User
Longtime User
I'm trying to convert the value of a date field from a query (number-to-string) starting from the example of the form dbutils, but it does not work because it returns always the numeric field. here is the code snippet:

sQuery.Append("SELECT [DocNo] AS Numero Fattura, Date(DocumentDate / 1000, 'unixepoch', 'localtime') AS Data......

what is wrong?
thank you very much
roberto
 
Sort by date Sort by votes

Roberto P.

Well-Known Member
Licensed User
Longtime User
ciao Erel, il db è SqlLite. Ho trovato le capacità di formattazione. I post nel caso sia utile a qualcuno.
grazie

sQuery.Append (", strftime ('% d /% m /% Y', DocumentDate / 1000, 'unixepoch') come dati")
sQuery.Append (", strftime ('% Y', DocumentDate / 1000, 'unixepoch') AS Anno")
sQuery.Append (", strftime ('% m', DocumentDate / 1000, 'unixepoch') AS Mese")
 
Upvote 0
You must log in or register to reply here.

Similar Threads

J
  • Question
Android Question sf = Main.mysql.ExecQueryAsync()
Replies
2
Views
1K
julio lutjens
J
  • Article
B4J Library [B4X] [B4XLib] SD_SQL (direct access to MySQL, MariaDB, MS SQL, FireBird)
2 3 4
Replies
64
Views
23K
Star-Dust
D
  • Locked
  • Question
Android Question MSSQL Query to MSSQL DB
Replies
10
Views
2K
Erel
  • Locked
  • Article
B4J Library [B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)
5 6 7
Replies
138
Views
144K
Erel
  • Locked
  • Article
Android Tutorial Remote Database Connector (RDC) - Connect to any remote DB
20 21 22
Replies
423
Views
315K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…